Sdílet prostřednictvím


DatabaseRole.Deny Method (ObjectPermissionSet, String)

Denies the specified set of permissions for the specified grantee on the database role.

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 DatabaseRole 
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 database role.

Implements

IObjectPermission.Deny(ObjectPermissionSet, String)

Examples

Granting, Revoking, and Denying Permissions

See Also

Reference

DatabaseRole Class

Deny Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Managing Users, Roles, and Logins

Database-Level Roles

CREATE ROLE (Transact-SQL)