REVOKE ROLE

Use the REVOKE ROLE command to revoke roles from groups.

Syntax

REVOKE ROLE 'role_name',...
 FROM GROUP 'group_name',... ;

Each role_name is a text string containing the unique name of a role being revoked.

Each group_name is the name of a group that will no longer be assigned the role or roles.

Note: The REVOKE ROLE command does not cascade within the role hierarchy. For example, if you revoke the AutoAdmin role from the SuperAdmin group after SuperAdmin has granted the AutoAdmin role to the LondonAdministrators group, the LondonAdministrators group still has the AutoAdmin role.

Example

revoke role 'AutoAdmin' from group 'LondonAdministrators';