Privilege Specification
Function
Defines the privileges which may be granted or revoked.
Invocation
It can appear in GRANT and REVOKE statements.
Syntax
where 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.
Description
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). |
Limitations
If a view is based on more than one base table (read-only view), then you can only grant the SELECT privilege.
ANSI Specifics
The keyword PRIVILEGES is mandatory when specifying ALL.
CONNX Specifics
The keyword PRIVILEGES is optional when specifying ALL.
![The syntax is ALL [PRIVILEGES] or SELECT/INSERT/DELETE or UPDATE/REFERENCES with (column_specification) [,]. You can separate many SELECT/INSERT/DELETE/UPDATE/REFERENCES statements with commas (,).](../cxi-webhelp/images/privilege_specification.png)