Friday, January 12, 2018

REVOKE Statement

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.



No comments:

Post a Comment