DROP ROLE

The DROP ROLE command is used for removing roles from the database. The optional IF EXISTS clause can be included to prevent an error if the specified role does not exist. If the IF EXISTS clause is omitted and the role does not exist, an error will be raised.

See also CREATE ROLE.

Syntax

drop_role_statement ::=
   DROP ROLE [IF EXISTS] <role_name>

role_name ::= identifier

Parameters

Parameter

Description

role_name

Role name to be removed

Examples

DROP ROLE new_role;

Permissions

To drop a role, the current role must have a SUPERUSER permission.

You can learn more about system permissions in the access control guide.