共用方式為


DatabaseRole.EnumObjectPermissions 方法 (ObjectPermissionSet)

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

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Function EnumObjectPermissions ( _
    permissions As ObjectPermissionSet _
) As ObjectPermissionInfo()
'用途
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[]

參數

傳回值

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

實作

IObjectPermission.EnumObjectPermissions(ObjectPermissionSet)

範例

管理使用者、角色和登入

請參閱

參考

DatabaseRole 類別

EnumObjectPermissions 多載

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

資料庫層級角色

sys.database_permissions (Transact-SQL)