The following elements are common between the GRANT, REVOKE, and LIST PERMISSIONS commands.

INSERT

Allows designated users to add rows to the specified table or view.

UPDATE

Allows designated users to alter information in the specified table or view.

SELECT

Allows designated users read-only access to all columns of all rows of the specified table or view.

DELETE

Allows designated users to delete rows from the specified table or view.

ALL [PRIVILEGES]

Allows designated users to perform all four query functions (INSERT, UPDATE, SELECT, DELETE) on the specified table or view. PRIVILEGES is an optional keyword.

[TABLE] <table name>

Identifies the table. You can qualify the table with an authorization identifier. TABLE is an optional keyword.

[TABLE] <view name>

Identifies the view. You can qualify the view with an authorization identifier. TABLE is an optional keyword.

<auth ID>

Assigns the specified permission to the designated user. Supplying the authorization identifier is optional.

* (asterisk)

Indicates that all tables of the database are included in the permission statement.

<usercode>

Identifies the usercode being given the permission.

PUBLIC

Assigns the specified permission to all users.