REVOKE Statement (Microsoft Access SQL)

  • Article
Access Developer Reference

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