Login.Deny Method (ObjectPermissionSet, String)

Denies the specified set of permissions for the specified grantee on the login account.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub Deny ( _
    permission As ObjectPermissionSet, _
    granteeName As String _
)
'Usage
Dim instance As Login 
Dim permission As ObjectPermissionSet 
Dim granteeName As String

instance.Deny(permission, granteeName)
public void Deny(
    ObjectPermissionSet permission,
    string granteeName
)
public:
virtual void Deny(
    ObjectPermissionSet^ permission, 
    String^ granteeName
) sealed
abstract Deny : 
        permission:ObjectPermissionSet * 
        granteeName:string -> unit  
override Deny : 
        permission:ObjectPermissionSet * 
        granteeName:string -> unit
public final function Deny(
    permission : ObjectPermissionSet, 
    granteeName : String
)

Parameters

  • granteeName
    Type: System.String
    A String value that specifies the grantee to be denied the specified set of permissions on the logon.

Implements

IObjectPermission.Deny(ObjectPermissionSet, String)

Examples

Granting, Revoking, and Denying Permissions

See Also

Reference

Login Class

Deny Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Managing Users, Roles, and Logins

Principals (Database Engine)

CREATE LOGIN (Transact-SQL)