doc/user/content/sql/revoke-role.md
REVOKE revokes membership of a role from the target role.
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>. |
REVOKE data_scientist FROM joe;
REVOKE data_scientist FROM joe, mike;
The privileges required to execute this statement are:
{{% include-headless "/headless/sql-command-privileges/revoke-role" %}}