GRANT (Authentication)

Associates an authentication record to one or more users and roles.

Syntax

GRANT AUTHENTICATION auth‑method‑name TO grantee[,...] 

Parameters

auth‑method‑name

Name of the authentication method to associate with one or more users or roles.

grantee

Specifies who is associated with the authentication method, one of the following:

Privileges

Superuser

Examples

  • Associate v_ldap authentication with user jsmith:
    => GRANT AUTHENTICATION v_ldap TO jsmith;
  • Associate v_gss authentication to the role DBprogrammer:
    => CREATE ROLE DBprogrammer;
    => GRANT AUTHENTICATION v_gss TO DBprogrammer;
  • Associate client authentication method v_localpwd with role PUBLIC, which is assigned by default to all users:
    => GRANT AUTHENTICATION v_localpwd TO PUBLIC;

See Also