REVOKE (TSQL Statement)

remove permission(s) ON the specified object TO the specified principal(s).

Syntax

REVOKE <permission> [,... n]
    ON [schema_name .] object_name
    { TO | FROM } { ALL | { principal [,... n] } }

<permission> ::= SELECT | UPDATE | INSERT | DELETE

Arguments

<permission>
is a permission to remove.
[schema_name.]object_name
is the object on which the permission(s) will be removed.
principal
is the name of a user or a role from which the permission(s) will be removed.
ALL
permissions will be removed from all principals.

Remarks

Only sa or dbo is allowed to execute this statement.

REVOKE removes permissions that have been granted by GRANT permissions or denied by DENY permissions.

Examples

REVOKE SELECT, INSERT, UPDATE, DELETE ON clients FROM igor;