DENY Statement : DENY « User Role « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. User Role
  3. DENY
The DENY statement prevents users from performing actions. 
This statement has the following syntax form:

DENY permission_list [ON scope]
TO principal_list [CASCADE]
[AS {windows_group|sqlserver_login|db_user|db_role|appl_role}]

DENY CREATE TABLE, CREATE PROCEDURE TO peter, 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