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.