DROP AUTHENTICATION

Drops an authentication method.

Syntax

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

`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.

Superuser

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;