GRANT Statement (Microsoft Access SQL)

  • Article
Access Developer Reference

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

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