Name
GRANT (Object Privileges)
Synopsis
GRANT {object_priv[,object_priv ...] | ALL [PRIVILEGES]}
[column [,column...]] ON
{ [schema.]object_name
| DIRECTORY directory_name
| JAVA {SOURCE | RESOURCE} [schema.]java_object
}
TO {username | role | PUBLIC}
[WITH GRANT OPTION]Grants privileges on a database object to one or more users or roles.
Keywords
- object_priv
Specifies the name of the object privilege to be granted. Valid privileges are ALTER, DELETE, EXECUTE, INDEX, INSERT, REFERENCES, SELECT, and UPDATE.
- object_name
Name of the object on which privileges are to be granted.
- DIRECTORY
Specifies the name of a directory object on which privileges are to be granted.
- JAVA SOURCE
Specifies the name of a Java source object on which privileges are to be granted.
- JAVA RESOURCE
Specifies the name of a Java resource object on which privileges are to be granted.
- username
Name of the user who will be granted the object privilege.
- role
Name of a role that will be granted the object privilege.
- PUBLIC
Specifies that the object privilege be granted to all current and future users.
- WITH GRANT OPTION
Specifies that the grantee of the privilege can grant the privilege to others.
Common keywords and clauses: column, schema.