GRANT Statement
Grants specific privileges to an existing user or group.
Syntax
GRANT {privilege[, privilege, …]} ON
{TABLE table |
OBJECT object|
CONTAINER container } TO {authorizationname[, authorizationname, …]}
The GRANT statement has these parts:
| Part | Description |
|---|---|
| privilege | The privilege or privileges to be granted. Privileges are specified using the following keywords:
SELECT, DELETE, INSERT, UPDATE, DROP, SELECTSECURITY, UPDATESECURITY, DBPASSWORD, UPDATEIDENTITY, CREATE, SELECTSCHEMA, SCHEMA and UPDATEOWNER. |
| tablename | Any valid table name. |
| object | This can encompass any non-table object. A stored query (view or procedure) is one example. |
| container | The name of a valid container. |
| authorizationname | A user or group name. |