Revoking a System Privilege from a User

Revoke a specific system privilege and the right to administer the system privilege from specific users.

Prerequisites

Administrative privilege over the system privilege being revoked.

Task

Warning! The syntax to revoke a system privilege applies to all system privileges except the CHANGE PASSWORD and SET USER system privileges.

To revoke a system privilege from a user, execute one of these statements:

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 [,...]`

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 [,...]

Example:

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