DROP AUTHENTICATION
Drops an authentication method that has been created but not granted to any users. If you try to drop an authentication method that has been granted to one or more users, the DROP operation fails. To successfully drop an authentication method that is currently granted to a user, use the CASCADE keyword.
Syntax
DROP AUTHENTICATION auth_method_name [ CASCADE ]
Parameters
auth_method_name
|
Name of the authentication method to drop. Type: VARCHAR (not case sensitive) |
Privileges
Must have DBADMIN privileges.
Examples
To delete an authentication record for md5_auth
, use the following command:
=> DROP AUTHENTICATION md5_auth;
To delete an authentication record for a method that has been granted to a user, use the CASCADE keyword:
=> CREATE AUTHENTICATION localpwd METHOD 'password' LOCAL; => GRANT AUTHENTICATION localpwd TO jsmith; => DROP AUTHENTICATION localpwd CASCADE;