Méthode Column.EnumUserPermissions
Enumerates a list of permissions for a specified user.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public Function EnumUserPermissions ( _
username As String _
) As DataTable
'Utilisation
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
Paramètres
- username
Type : System.String
A String value that specifies the database user.
Valeur de retour
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. |
Exemples
Utilisation des objets de base de données