Column.EnumUserPermissions Method

Articolo
12/15/2008

Enumerates a list of permissions for a specified user.

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

Sintassi

'Dichiarazione
Public Function EnumUserPermissions ( _
    username As String _
) As DataTable

public DataTable EnumUserPermissions (
    string username
)

public:
DataTable^ EnumUserPermissions (
    String^ username
)

public DataTable EnumUserPermissions (
    String username
)

public function EnumUserPermissions (
    username : String
) : DataTable

Parametri

username
A String value that specifies the database user.

Valore restituito

A DataTable object value that contains the enumerated list of permissions for the specified user. The table describes the different columns of the returned DataTable.

Column	Data type	Description
Grantee	String	The name of the principal that received the permission.
Grantor	String	The name of the principal that granted, revoked, or denied permission.
PermissionState	Int32	The numeric value that represents the ASCII character code for the first letter of the permission state, Deny = 68, Revoke = 82, and Grant = 71.
Code	Int32	The code that specifies the permission type. See sys.database_permissions (Transact-SQL).
ObjectClass	String	The type of object to which permission is granted. See sys.database_permissions (Transact-SQL).
GranteeType	String	The type of grantee. See PrincipalType class.
GrantorType	String	The type of grantor. See PrincipalType class.
GolumnName	String	The name of the column.

Osservazioni

Questo spazio dei nomi, classe o membro è supportato solo nella versione 2.0 di Microsoft .NET Framework.

Esempio

How to: Create, Alter, and Remove a Table 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.

Piattaforme

Piattaforme di sviluppo

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Piattaforme di destinazione

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Condividi tramite