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






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