Column.EnumUserPermissions Method
Enumerates a list of permissions for a specified user.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Declaration
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
Parameter
- username
A String value that specifies the database user.
Rückgabewert
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. |
Hinweise
Der Namespace, die Klasse oder das Element wird nur in der Version 2.0 von Microsoft .NET Framework unterstützt.
Beispiel
How to: Create, Alter, and Remove a Table in Visual Basic .NET
Threadsicherheit
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.
Plattformen
Entwicklungsplattformen
Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.
Zielplattforme
Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.
Siehe auch
Verweis
Column Class
Column Members
Microsoft.SqlServer.Management.Smo Namespace