Purpose
You can use this statement to drop a role.
Note
After you drop a role, it will be revoked from all users and roles to which this role is granted, and be dropped from the database. User sessions where this role is enabled are not affected. After a role is dropped, this role cannot be enabled for new user sessions.
Syntax
DROP ROLE role_name ;
Parameters
| Parameter | Description |
|---|---|
| role_name | The name of the role to be dropped. |
Examples
Drop the role named role1.
obclient> DROP ROLE role1;
Query OK, 0 rows affected