Function:

Defines the privileges which may be granted or revoked.

Invocation:

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.

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 the SELECT privilege is the only one to be granted in this case.

ANSI Specifics:

The keyword PRIVILEGES is mandatory when specifying ALL.

CONNX Specifics:

The keyword PRIVILEGES is optional when specifying ALL.

 

Example:

See the GRANT/REVOKE statements for examples.