Server.Deny Method

Include Protected Members
Include Inherited Members

Denies the specified set of permissions for the specified grantees on the instance of SQL Server.

Overload List

  Name Description
Public method Deny(ServerPermissionSet, String) Denies the specified set of permissions for the specified grantee on the instance of SQL Server.
Public method Deny(ServerPermissionSet, array<String[]) Denies the specified set of permissions for the specified grantees on the instance of SQL Server.
Public method Deny(ServerPermissionSet, String, Boolean) Denies the specified set of permissions for the specified grantee and other users that the grantee granted the specified set of permissions on the instance of SQL Server.
Public method Deny(ServerPermissionSet, array<String[], Boolean) Denies the specified set of permissions for the specified grantees and other users that the grantee granted the specified set of permissions on the instance of SQL Server.

Top

Remarks

The Deny method has several overloads that give you a choice of whether to deny permissions to a single grantee or several grantees. You can also decide whether to include the Cascade option. The Cascade option determines whether the permissions that were denied by the grantees are also denied to other users.