Column.EnumUserPermissions Method
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 |
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 的硬件和软件要求。
目标平台
有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。
请参阅
参考
Column Class
Column Members
Microsoft.SqlServer.Management.Smo Namespace