REVOKE statement (Microsoft Access SQL)

Applies to: Access 2013, Office 2013

Revokes specific privileges from an existing user or group.

Syntax

REVOKE {privilege[, privilege, …]} ON {TABLE table | OBJECT object|

CONTAINTER container} FROM {authorizationname[, authorizationname, …]}

The REVOKE statement has these parts:

Part	Description
privilege	The privilege or privileges to be revoked. Privileges are specified using the following keywords: SELECT, DELETE, INSERT, UPDATE, DROP, SELECTSECURITY, UPDATESECURITY, DBPASSWORD, UPDATEIDENTITY, CREATE, SELECTSCHEMA, SCHEMA, and UPDATEOWNER.
table	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.