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