REVOKE (Authentication)

Revokes an authentication method that you have granted to (associated with) one or more users or roles.

Syntax

REVOKE AUTHENTICATION auth-method-name FROM 
   { Public | user_or_role | user_or_role1, user_or_role2, user_or_role3,... }

auth_method_name

Name of the authentication method which you want to revoke from one or more users.

Type: VARCHAR

user_or_role, user_or_role1, user_or_role2, user_or_role3, ...

Names of users or user roles from whom you want to revoke the authentication method.

Type: VARCHAR

Must have DBADMIN privileges.

This example revokes v_ldap authentication from user jsmith:

=> REVOKE AUTHENTICATION v_ldap FROM jsmith;

This example revokes v_gss authentication from the role DBprogrammer:

=> REVOKE AUTHENTICATION v_gss FROM DBprogrammer;

This example removes localpwd as the default client authentication method:

=> REVOKE AUTHENTICATION localpwd from Public;