9. Extended Statements : Grant : Description
 
Share this page                  
Description
The grant statement enables a DBA or user to control access to tables. To remove privileges, use the REVOKE statement. The following table describes the GRANT statement parameters.
By default, neither the public nor any user has any table privileges. Table privileges must be granted explicitly. Valid table privileges are:
Select
Insert
Update
For update, a list of columns can optionally be specified; if the column list is omitted, update privilege is granted to all updatable columns of the table or view.
Delete
References—The references privilege enables specified users to create referential constraints that reference the specified tables and columns. For details about referential constraints, see Create Table (extended) (see page Create Table (extended)).
A list of columns can optionally be specified. If the column list is omitted, references privilege is granted to all updatable columns of the table. You cannot grant the references privilege on a view.
All [privileges]—All grants select, insert, update, delete, and references on the specified objects to the specified users.