共用方式為


DatabaseRole.EnumObjectPermissions 方法 (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.

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

語法

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

參數

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

傳回值

型別: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(String, ObjectPermissionSet)

範例

管理使用者、角色和登入

請參閱

參考

DatabaseRole 類別

EnumObjectPermissions 多載

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

資料庫層級角色

sys.database_permissions (Transact-SQL)