Share via


DatabaseRole.EnumObjectPermissions Method (String, ObjectPermissionSet)

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

'Declaration
Public Function EnumObjectPermissions ( _
    granteeName As String, _
    permissions As ObjectPermissionSet _
) As ObjectPermissionInfo()
'Usage
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)