Aracılığıyla paylaş

DatabaseRole.EnumObjectPermissions Method (String, ObjectPermissionSet)

  • Makale

Returns a list of object permissions assigned to the referenced database role for the specified member of the role and for the specified set of permissions.

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

Syntax

'Bildirim
Public Function EnumObjectPermissions ( _
    granteeName As String, _
    permissions As ObjectPermissionSet _
) As ObjectPermissionInfo()
'Kullanım
Dim instance As DatabaseRole
Dim granteeName As String
Dim permissions As ObjectPermissionSet
Dim returnValue As ObjectPermissionInfo()

returnValue = instance.EnumObjectPermissions(granteeName, _
    permissions)

public ObjectPermissionInfo[] EnumObjectPermissions(
    string granteeName,
    ObjectPermissionSet permissions
)

public:
virtual array<ObjectPermissionInfo^>^ EnumObjectPermissions(
    String^ granteeName, 
    ObjectPermissionSet^ permissions
) sealed

abstract EnumObjectPermissions : 
        granteeName:string * 
        permissions:ObjectPermissionSet -> ObjectPermissionInfo[] 
override EnumObjectPermissions : 
        granteeName:string * 
        permissions:ObjectPermissionSet -> ObjectPermissionInfo[] 

public final function EnumObjectPermissions(
    granteeName : String, 
    permissions : ObjectPermissionSet
) : ObjectPermissionInfo[]

Parameters

  • granteeName
    Type: System.String
    A String value that specifies the name of the database role member.

Return Value

Type: array<Microsoft.SqlServer.Management.Smo.ObjectPermissionInfo[]
An array of ObjectPermissionInfo object values that contain information about object permissions assigned to the database role.

Implements

IObjectPermission.EnumObjectPermissions(String, ObjectPermissionSet)

Examples

Managing Users, Roles, and Logins

See Also

Reference

DatabaseRole Class

EnumObjectPermissions Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Database-Level Roles

sys.database_permissions (Transact-SQL)