Mega Code Archive

 

Categories / MSSQL Tutorial / User Role

 

The DENY statement is used to explicitly prohibit a user or role members from performing a specific action on an object

DENY  INSERT ON Product TO Paul DENY EXEC ON spDeletePurchaseEmployee TO Paul