REVOKE ROLE

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

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;

Privileges

The privileges required to execute this statement are:

CREATEROLE privileges on the systems.

Useful views

mz_internal.mz_show_role_members
mz_internal.mz_show_my_role_members

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