Remove a user or role as a member of a role. The user or role loses the ability to use any underlying system privileges or roles of a role, along with the ability to administer the role, if granted.
Revoke Type | Statement |
---|---|
Role membership and all administrative rights to the role |
REVOKE ROLE role_name FROM grantee [,...] |
Administrative rights to the role only |
REVOKE ADMIN OPTION FOR ROLE role_name FROM grantee [,...] |