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

Name

GRANT

Synopsis

To grant system privileges or roles:

GRANT {system_privilege | role | ALL PRIVILEGES} TO grantee
        [IDENTIFIED BY password] [WITH ADMIN OPTION]

To grant object privileges:

GRANT {object_privilege | ALL [PRIVILEGES]}
                [column_name [,column_name . . .]]
        ON {schema.object | DIRECTORY directory_name | 
                JAVA (SOURCE | RESOURCE) [schema.]object}
        TO grantee [WITH GRANT OPTION] [WITH HIERARCHY OPTION]

Grants privileges or roles to a user or role. In order to grant a privilege, you must have previously been granted the privilege or role with the WITH ADMIN OPTION, described in the following “Keywords” section. You can also grant privileges if you have GRANT ANY PRIVILEGE (for system privileges), GRANT ANY ROLE (for roles), GRANT OPTION (for schema objects), or own the object.

System privileges and schema object privileges cannot be granted in the same GRANT statement.

Keywords

IDENTIFIED BY password

Can be used to identify an existing user by password or to create a new user with the specified password. New with Oracle9i.

ALL PRIVILEGES

Grants all privileges to the user or role, except the SELECT ANY DICTIONARY privilege. New with Oracle9i.

WITH ADMIN OPTION

Allows the user to grant or revoke the system privilege or role or to alter or drop the role.

WITH GRANT OPTION

Like the WITH ADMIN OPTION, allows the user or role to grant or revoke object privilege to other users or roles.

JAVA SOURCE | RESOURCE

Grants access to Java source code or a Java resource. New with Oracle8i.

WITH HIERARCHY ...
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