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