Column.EnumUserPermissions Method

發行項
12/16/2008

Enumerates a list of permissions for a specified user.

命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

語法

'宣告
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

參數

username
A String value that specifies the database user.

傳回值

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.

備註

只有 Microsoft .NET Framework 2.0 版支援此命名空間、類別或成員。

範例

How to: Create, Alter, and Remove a Table in Visual Basic .NET

執行緒安全性

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.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台