GRANT (Object Privileges)
GRANT {object_priv
[(column_list
)][,
object_priv
[ (column_list
) ]...] | ALL [PRIVILEGES] } { ON [schema
.]object_name
| ON DIRECTORYdirectory_name
} TO {username
|role
| PUBLIC} [WITH GRANT OPTION]
Grants privileges on a database object to one or more users or roles.
Specifies the name of the object privilege to be granted. Valid privileges are: ALTER, DELETE, EXECUTE, INDEX, INSERT, REFERENCES, SELECT, and UPDATE. ALL PRIVILEGES grants all privileges for the object that have been granted to the grantor.
Specifies one or more columns in the object to which the object privilege applies.
Specifies the name of the object on which privileges are being granted.
Specifies an Oracle8 directory (directory_name) to be granted.
Specifies the name of the user to whom the object privilege will be granted.
Specifies the name of a role to which the object privilege will be granted.
Specifies that the object privilege will be granted to all current and future users.
Specifies that the grantee of the privilege can grant the privilege to others.