REVOKE ROLE
REVOKE revokes membership of one role from another role. Roles can be members
of other roles, as well as inherit all the attributes and privileges of those
roles. This membership can also be revoked.
WARNING! Currently, roles have limited functionality in Materialize. This is part of the
work to enable Role-based access control (RBAC) in a future release (#11579).
Syntax
| Field | Use |
|---|---|
| role_name | The role name to remove member_name from. |
| member_name | The role name to remove from role_name. |
Details
You may not set up circular membership loops.
Examples
REVOKE data_scientist FROM joe;
REVOKE data_scientist FROM joe, mike;