Revoke a specific system privilege and the right to administer the system privilege from specific users.
Administrative Option | Statement |
---|---|
Administrative rights only |
REVOKE ADMIN OPTION FOR system_privilege FROM grantee [,...] |
System privilege and any administrative rights |
REVOKE system_privilege FROM grantee [,...] |
Assuming Mary and Joe were originally granted the BACKUP DATABASE system privilege with administrative rights, execute this statement to remove Mary's administrative rights to the system privilege only, leaving her ability to use the system privilege:
REVOKE ADMIN OPTION FOR BACKUP DATABASE FROM Mary
Execute this statement to remove the system privilege itself and all administrative rights from Joe:
REVOKE BACKUP DATABASE FROM Joe