Metodo 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.

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

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

Parametri

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

Valore restituito

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

Implementa

IObjectPermission.EnumObjectPermissions(String, ObjectPermissionSet)

Esempi

Gestione di utenti, ruoli e account di accesso

Vedere anche

Riferimento

DatabaseRole Classe

Overload EnumObjectPermissions

Spazio dei nomi Microsoft.SqlServer.Management.Smo

Altre risorse

Ruoli a livello di database

sys.database_permissions (Transact-SQL)