DROP ROLE

Syntax

DROP ROLE role_name;

Description

Drops a custom role within the organization.

Note You cannot drop built-in roles.

There are guidelines for dropping custom roles:

• Only the owner of a role, or a role with MANAGE_MEMBERS, can drop a role.

• You cannot drop any role that is the owner of an object. If you do wish drop such a role, you must first transfer ownership of the object (or objects) from the role you wish to drop to a role you intend to keep. To transfer ownership of an object, use GRANT OWNERSHIP.

• You also cannot drop any role that has been granted any other roles. In this case, you must revoke any such granted roles first. To revoke any granted roles, use REVOKE ROLE.

Arguments

role_name

The name of the role to drop. If the name is case sensitive you must wrap it in double quotes; otherwise the system uses the lower case name.

Examples

<no-db>/<no-store># DROP ROLE test_role;
+------------+------------+------------+------------------------------------------+
|  Type      |  Name      |  Command   |  Summary                                 |
+============+============+============+==========================================+
| role       | test_role  | DROP       | role "test_role" was successfully        |
|            |            |            | dropped                                  |
+------------+------------+------------+------------------------------------------+