DROP AUTHENTICATION

Drops an authentication method.

Syntax

DROP AUTHENTICATION [ IF EXISTS ] auth‑method‑name [ CASCADE ]

Parameters

IF EXISTS

Specifies not to report an error if the authentication method to drop does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them.

auth‑method‑name

Name of the authentication method to drop.

CASCADE Required if the authentication method to drop is granted to users. In this case, omission of this option causes the drop operation to fail.

Privileges

Superuser

Examples

Delete authentication method md5_auth:

=> DROP AUTHENTICATION md5_auth;

Use CASCADE to drop authentication method that was granted to a user:

=> CREATE AUTHENTICATION localpwd METHOD 'password' LOCAL;
=> GRANT AUTHENTICATION localpwd TO jsmith;
=> DROP AUTHENTICATION localpwd CASCADE;

See Also