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;