DROP ROLE#
Synopsis#
DROP ROLE [ IF EXISTS ] role_name
[ IN catalog ]
Description#
DROP ROLE
drops the specified role.
For DROP ROLE
statement to succeed, the user executing it should possess
admin privileges for the given role.
The optional IF EXISTS
prevents the statement from failing if the role
isn’t found.
The optional IN catalog
clause drops the role in a catalog as opposed
to a system role.
Examples#
Drop role admin
DROP ROLE admin;