REVOKE Statement

Microsoft Office Access 2003

previous page next page

REVOKE Statement

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 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 GRANT Statement
previous page start next page