Syntax for Securing Database Resources › GRANT Table Access Privileges › GRANT Table Access Privileges Parameters

GRANT Table Access Privileges Parameters

ACCESS

Gives the DELETE, INSERT, SELECT, and UPDATE privileges on the table-like object identified in the ON parameter to the users or groups identified in the TO parameter.

DELETE

Gives the DELETE privilege on the table-like object identified in the ON parameter to the users or groups identified in the TO parameter.

The DELETE privilege on a table-like object allows a user to delete rows from the table or view.

INSERT

Gives the INSERT privilege on the table-like object identified in the ON parameter to the users or groups identified in the TO parameter.

The INSERT privilege on a table-like object allows a user to insert rows into the table or view.

SELECT

Gives the SELECT privilege on the table-like object identified in the ON parameter to the users or groups identified in the TO parameter.

The SELECT privilege on a table-like object allows a user to the following:

• Retrieve data from the table-like object.
• Name the table-like object in a subquery.
• Define a view derived from the table-like object.

UPDATE

Gives the UPDATE privilege on the table-like object identified in the ON parameter to the users or groups identified in the TO parameter.

The UPDATE privilege on a table-like object allows a user to modify data in the table-like object.

ON table table-name

Specifies the table-like object to which the table access privileges apply.

Note: Expanded syntax for table-name is presented in Notes on Security Statement Syntax.

You can wildcard any identifier when you grant access on table-name. If you specify schema-name in table-name, the wildcard character is valid after the period following schema-name.

Note: For more information about wildcarding, see Using a Wildcard.

If you do not specify schema-name, it defaults to the current schema in effect for your session.

TO

Specifies the users or groups to whom you are giving table access privileges.

PUBLIC

Specifies all users.

authorization-identifier

Identifies a user or group.

Note: Expanded syntax for authorization-identifier is presented in chapter Notes on Security Statement Syntax.

WITH GRANT OPTION

Gives the privilege of granting the specified access privileges on the named table or view to the users or groups identified in the TO parameter.

A privilege granted with the WITH GRANT OPTION is called a grantable privilege.