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: User name Role PUBLIC: The default role of all users.

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

• REVOKE (Authentication)
• Granting and Revoking Privileges