Метод Column.EnumUserPermissions

Статья
04/26/2013

Enumerates a list of permissions for a specified user.

Пространство имен: Microsoft.SqlServer.Management.Smo
Сборка: Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
Public Function EnumUserPermissions ( _
    username As String _
) As DataTable
'Применение
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

Параметры

username
Тип: System.String
A String value that specifies the database user.

Возвращаемое значение

Тип: 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	String	The name of the principal that received the permission.
Grantor	String	The name of the principal that granted, revoked, or denied permission.
PermissionState	Int32	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 the PrincipalType class.
GrantorType	String	The type of grantor. See the PrincipalType class.
GolumnName	String	The name of the column.

Примеры

Работа с объектами базы данных

См. также

Справочник

Column Класс

Пространство имен Microsoft.SqlServer.Management.Smo

Поделиться через