Revokes specific privileges from an existing user or group.
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. |