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).


REVOKE role_name FROM GROUP member_name ,
Field Use
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;
Back to top ↑