Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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
'Usage
Dim instance As Column
Dim username As String
Dim returnValue As DataTable
returnValue = instance.EnumUserPermissions(username)
public DataTable EnumUserPermissions(
string username
)
public:
DataTable^ EnumUserPermissions(
String^ username
)
member EnumUserPermissions :
username:string -> DataTable
public function EnumUserPermissions(
username : String
) : DataTable
Parameters
- username
Type: System.String
A String value that specifies the database user.
Return Value
Type: System.Data.DataTable
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 |
The name of the principal that received the permission. |
|
Grantor |
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 |
The code that specifies the permission type. See sys.database_permissions (Transact-SQL). |
|
ObjectClass |
The type of object to which permission is granted. See sys.database_permissions (Transact-SQL). |
|
GranteeType |
The type of grantee. See the PrincipalType class. |
|
GrantorType |
The type of grantor. See the PrincipalType class. |
|
GolumnName |
The name of the column. |