DROP ROLE

DROP ROLE remove roles.

Learn more about the permission system in the access control guide.

See also CREATE ROLE.

Permissions

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

Syntax

drop_role_statement ::=
   DROP ROLE role_name ;

role_name ::= identifier

Parameters

Parameter

Description

role_name

The name of the role to drop.

Examples

Dropping a role

DROP ROLE new_role;