Database Reference
In-Depth Information
Figure 23.9
Revoking
Privileges.
entirely different privileges, such as EXECUTE, because they are a different
type of database object.
What if you have granted a privilege (system or object) to PUBLIC and
later decide that you would rather only grant that privilege to a small set of
users? You must remove the privilege you originally granted. This brings us
to the REVOKE command.
23.2.2
Revoking Privileges
You use the REVOKE command to remove both system privileges and
object privileges. Like the GRANT command, the REVOKE command
has two similar formats: one for revoking system privileges and one for
revoking object privileges. Figure 23.9 shows the syntax for the REVOKE
command.
Revoke System Privileges
. To revoke a system privilege, you must
have been granted the same system privilege WITH ADMIN
OPTION. The SYSTEM user has this privilege.
