Server.Deny Method

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

Remarks

Updated text:

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.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Overload List

Name Description
Server.Deny (ServerPermissionSet, String)
Denies the specified set of permissions for the specified grantee on the instance of Microsoft SQL Server.
Server.Deny (ServerPermissionSet, String[])
Denies the specified set of permissions for the specified grantees on the instance of Microsoft SQL Server.
Server.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 Microsoft SQL Server.
Server.Deny (ServerPermissionSet, 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 Microsoft SQL Server.

See Also

Reference

Server Class
Server Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

How to: Grant Server Permissions in Visual Basic .NET
Granting, Revoking, and Denying Permissions
Managing Servers

Change History

Release

History

New content:
  • Added code sample to the Example section.