This documentation is archived and is not being maintained.

REVOKE Statement (Microsoft Access SQL)

Office 2007

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:

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

tableAny 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

GRANT Statement



Show: