Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

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).

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page