DENY#
Denies permissions on a securable to one or more principals, overriding any grants they may have.
Syntax#
Arguments#
- ALL [ PRIVILEGES ]
Denies all permissions applicable to the securable.
- permissions
A comma-separated list of permissions to deny.
- ON securable
The object the permissions apply to.
- TO principals
The users or roles the permissions are denied to.
Examples#
DENY DELETE ON dbo.Product TO analyst;