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