Drops an authentication method.
DROP AUTHENTICATION [ IF EXISTS ] auth‑method‑name [ CASCADE ]
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.
Name of the authentication method to drop.
||Required if the authentication method to drop is granted to users. In this case, omission of this option causes the drop operation to fail.|
Delete authentication method
=> DROP AUTHENTICATION md5_auth;
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;