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.

See Also

ADD USER Statement	CREATE TABLE Statement
ALTER USER or DATABASE Statement	CREATE USER or GROUP Statement
ALTER TABLE Statement	CREATE VIEW Statement
CONSTRAINT Clause	DROP Statement
CREATE INDEX Statement	DROP USER or GROUP Statement
CREATE PROCEDURE Statement	REVOKE Statement