DROP ROLE (Enterprise)

The DROP ROLE statement removes one or more SQL roles.

Note:
DROP ROLE is an enterprise-only feature.

Considerations

• The admin role cannot be dropped, and root must always be a member of admin.
• A role cannot be dropped if it has privileges. Use REVOKE to remove privileges.

Required privileges

Roles can only be dropped by super users, i.e., members of the admin role.

Synopsis

Parameters

Example

In this example, first check a role's privileges. Then, revoke the role's privileges and remove the role.

> SHOW GRANTS ON documents FOR dev_ops;

+------------+--------+-----------+---------+------------+
|  Database  | Schema |   Table   |  User   | Privileges |
+------------+--------+-----------+---------+------------+
| jsonb_test | public | documents | dev_ops | INSERT     |
+------------+--------+-----------+---------+------------+

> REVOKE INSERT ON documents FROM dev_ops;

Note:
All of a role's privileges must be revoked before the role can be dropped.

> DROP ROLE dev_ops;

DROP ROLE 1

See also

• Authorization
• CREATE ROLE (Enterprise)
• SHOW ROLES
• GRANT
• SHOW GRANTS
• Other SQL Statements

Was this page helpful?
YesNo