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

Common Keywords and Clauses

The following keywords and clauses are valid for both the GRANT and REVOKE commands:

system_privilege

A system privilege, as described in the earlier “System Privileges” section.

role

An existing role.

ALL PRIVILEGES

Grants or revokes all system privileges except SELECT ANY DICTIONARY. For objects, grants all privileges that you have for the object, and the keyword PRIVILEGES is optional.

grantee

Can be one or more users, roles, or the keyword PUBLIC, which grants or revokes the privilege to all database users. If multiple grantees are specified, they should be separated by commas.

object_privilege

An object privilege, as described earlier in this chapter.

column_name

One or more columns on which to grant or revoke the INSERT, REFERENCES, or UPDATE object privileges. If you do not specify a column, the grantee has privilege on all columns in the table or view.

schema.object

Specifies the object on which to grant or revoke the privilege. If you do not specify a schema, Oracle assumes that the object is in your own schema.

DIRECTORY directory_name

Specifies the directory on which to grant or revoke a privilege.

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