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

GRANT All Table Privileges Parameters

ALL PRIVILEGES

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

ON table table-name

Identifies the table-like object to which the table privileges apply.

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

You can wildcard the identifier-components of 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 privileges.

PUBLIC

Specifies all users.

authorization-identifier

Identifies a user or group.

Note: Expanded syntax for authorization-identifier is presented in Using a Wildcard.

WITH GRANT OPTION

Gives the privilege of granting the all table privileges on table-name to the users or groups identified in the TO parameter. The owner of the resource, a holder of the applicable DBADMIN privilege, or a holder of SYSADMIN privilege can specify WITH GRANT OPTION.

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