DatabaseRole.EnumObjectPermissions Method (ObjectPermissionSet)

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

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

Syntax

'Declaration
Public Function EnumObjectPermissions ( _
    permissions As ObjectPermissionSet _
) As ObjectPermissionInfo()
'Usage
Dim instance As DatabaseRole 
Dim permissions As ObjectPermissionSet 
Dim returnValue As ObjectPermissionInfo()

returnValue = instance.EnumObjectPermissions(permissions)

public ObjectPermissionInfo[] EnumObjectPermissions(
    ObjectPermissionSet permissions
)

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

abstract EnumObjectPermissions : 
        permissions:ObjectPermissionSet -> ObjectPermissionInfo[] 
override EnumObjectPermissions : 
        permissions:ObjectPermissionSet -> ObjectPermissionInfo[] 

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

Parameters

• permissions
  Type: Microsoft.SqlServer.Management.Smo.ObjectPermissionSet
  An ObjectPermissionSet that specifies the set of object permissions.

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(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)