System Privileges
This section provides summary information for all of the Oracle system privileges.Several varieties of system privileges apply to more than one type of privilege:
- ANY
Gives the privilege to perform the action on objects in any schema. Without this keyword, a privilege is granted only on objects within the user’s schema. By default, the ANY keyword gives the user privilege on all objects in all schemas, including the SYS schema. To prevent access to the SYS schema with the ANY privilege, you can set the O7_DICTIONARY_ACCESSIBILITY initialization parameter to FALSE.
- ALTER
Gives the privilege to alter the type of object.
- CREATE
Gives the privilege to create the type of object.
- DROP
Gives the privilege to drop the type of object.
- EXECUTE
Gives the privilege to execute or reference the type of object.
- SELECT ANY
Gives the privilege to access objects. Because users always have the ability to access objects in their own schema, this variety is used only with the ANY keyword.
Each of these varieties of system privilege can be used with many of the system privilege types described in the following entries.
In each of the privilege entries, we’ve noted two categories of privileges: the common (those listed in the previous section, which apply to many different types of privileges) and the unique (those unique to that particular privilege type).