문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
번역
영문

Column.EnumUserPermissions 메서드

Enumerates a list of permissions for a specified user.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

public DataTable EnumUserPermissions(
	string username
)

매개 변수

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.

커뮤니티 추가 항목

추가
표시: