REVOKE ROLE
REVOKE revokes membership of a role from the target role.
Syntax
REVOKE <role_to_remove> [, ...] FROM <target_role> [, ...];
| Syntax element | Description |
|---|---|
<role_to_remove> |
The name of the role to remove from the <target_role>. |
<target_role> |
The name of the role from which the to remove the <role_to_remove>. |
Examples
REVOKE data_scientist FROM joe;
REVOKE data_scientist FROM joe, mike;
Privileges
The privileges required to execute this statement are:
CREATEROLEprivileges on the systems.