The DENY statement is used to explicitly prohibit a user or role members from performing a specific action on an object. : DENY « User Role « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. User Role
  3. DENY
DENY INSERT ON Product TO Paul
DENY EXEC ON spDeletePurchaseEmployee TO Paul
28.5.DENY
28.5.1.The DENY statement is used to explicitly prohibit a user or role members from performing a specific action on an object.
28.5.2.DENY Statement