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;