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.
Платформы
Платформы разработки
Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.
Целевые платформы
Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.
См. также
Справочник
Column Class
Column Members
Microsoft.SqlServer.Management.Smo Namespace