DROP ROLE

The DROP ROLE statement allows you to drop a role from your database.

Syntax

DROP ROLE roleName

roleName

The name of the role that you want to drop from your database.

Usage

Dropping a role has the effect of removing the role from the database dictionary. This means that no session user can henceforth set that role (see  CURRENT_ROLE function) will now have a NULL CURRENT_ROLE.

Dropping a role also has the effect of revoking that role from any user and role it has been granted to. See the  REVOKE statement for information on how revoking a role may impact any dependent objects.

Example

splice> DROP ROLE statsEditor_role;
0 rows inserted/updated/deleted

See Also