Defines the privileges which may be granted or revoked.
It can appear in GRANT and REVOKE statements.
Syntax:
l
column_specification |
Identifies the column upon which the GRANT or REVOKE statements will be based. The column name must be a column defined on the specified table or view. If you specify more than one table or view, the column identifier must be valid for all tables or views. |
Defines the privilege or set of privileges to be granted or revoked. These privileges are defined for specified tables or views.
The following privilege specifications may be defined:
SELECT |
Enables the selection of data from the table(s) or view(s). |
INSERT |
Enables the insertion of data in the table(s) or view(s). |
DELETE |
Enables the deletion of rows from the specified table(s) or view(s). |
UPDATE |
Enables the updating of data in the specified table(s) or view(s). The UPDATE privilege can be specified for a list of columns within the table(s) or view(s). |
If a view is based on more than one base table (read-only view), then the SELECT privilege is the only one to be granted in this case.
The keyword PRIVILEGES is mandatory when specifying ALL.
The keyword PRIVILEGES is optional when specifying ALL.
Example:
See the GRANT/REVOKE statements for examples.