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;

Limitations#

Some connectors do not support role management. See connector documentation for more details.

See also#

CREATE ROLE, SET ROLE, GRANT role, REVOKE role