GRANT Statement

Microsoft Office Access 2003

previous page next page

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


previous page start next page