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