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()
public ObjectPermissionInfo[] EnumObjectPermissions (
string granteeName,
ObjectPermissionSet permissions
)
public:
virtual array<ObjectPermissionInfo^>^ EnumObjectPermissions (
String^ granteeName,
ObjectPermissionSet^ permissions
) sealed
public final ObjectPermissionInfo[] EnumObjectPermissions (
String granteeName,
ObjectPermissionSet permissions
)
public final function EnumObjectPermissions (
granteeName : String,
permissions : ObjectPermissionSet
) : ObjectPermissionInfo[]
Parameters
- granteeName
A String value that specifies the name of the database role member.
- permissions
An ObjectPermissionSet that specifies the set of object permissions.
Return Value
An array of ObjectPermissionInfo object values that contain information about object permissions assigned to the database role.
Remarks
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
Example
How to: Use an SMO Method with a Parameter in Visual Basic .NET
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
See Also
Reference
DatabaseRole Class
DatabaseRole Members
Microsoft.SqlServer.Management.Smo Namespace
Other Resources
Managing Users, Roles, and Logins
Database Roles
sys.database_permissions (Transact-SQL)