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.