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).
|role_name||The role name to remove member_name from.|
|member_name||The role name to remove from role_name.|
You may not set up circular membership loops.
REVOKE data_scientist FROM joe;
REVOKE data_scientist FROM joe, mike;