Materialize/doc/user/content/sql/revoke-role.md

---

title: "REVOKE ROLE" description: "REVOKE revokes membership of one role from another role." menu: main:

parent: commands

---

REVOKE revokes membership of one role from another role. Roles can be members of other roles, as well as inherit all the privileges of those roles. This membership can also be revoked.

Syntax

{{< diagram "revoke-role.svg" >}}

Field	Use
_rolename	The role name to remove _membername from.
_membername	The role name to remove from _rolename.

Details

You may not set up circular membership loops.

Examples

REVOKE data_scientist FROM joe;

REVOKE data_scientist FROM joe, mike;

Privileges

The privileges required to execute this statement are:

{{< include-md file="shared-content/sql-command-privileges/revoke-role.md" >}}

Useful views

• mz_internal.mz_show_role_members
• mz_internal.mz_show_my_role_members

Related pages

• SHOW ROLE MEMBERSHIP
• CREATE ROLE
• ALTER ROLE
• DROP ROLE
• DROP USER
• GRANT ROLE
• ALTER OWNER
• GRANT PRIVILEGE
• REVOKE PRIVILEGE