Export (0) Print
Expand All

GRANT Statement (Microsoft Access SQL)

Office 2007

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:

PartDescription
privilegeThe 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.

tablenameAny valid table name.
objectThis can encompass any non-table object. A stored query (view or procedure) is one example.
containerThe name of a valid container.
authorizationnameA user or group name.
See Also

ADD USER Statement

ALTER TABLE Statement

ALTER USER or DATABASE Statement

CONSTRAINT Clause

CREATE INDEX Statement

CREATE PROCEDURE Statement

CREATE TABLE Statement

CREATE USER or GROUP Statement

CREATE VIEW Statement

DROP Statement

DROP USER or GROUP Statement

REVOKE Statement



Community Additions

ADD
Show:
© 2014 Microsoft