REVOKE ROLE¶
Removes a role from another role or a user.
- See also:
Syntax¶
REVOKE ROLE <name> FROM { ROLE <parent_role_name> | USER <user_name> }
Parameters¶
nameSpecifies the identifier for the role to revoke. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.
ROLE parent_role_nameRevokes the role from the specified role.
USER user_nameRevokes the role from the specified user.
Examples¶
REVOKE ROLE analyst FROM ROLE SYSADMIN;
REVOKE ROLE analyst FROM USER user1;