DatabasePermissionSetValue 열거형

정의

네임스페이스:

Microsoft.SqlServer.Management.Smo

어셈블리:

Microsoft.SqlServer.SqlEnum.dll

패키지:

Microsoft.SqlServer.SqlManagementObjects v172.64.0

가능한 모든 DatabasePermissions를 포함하는 열거형은 sys.fn_builtin_permissions 사용하여 새 버전의 SQL에서 최신 값을 확인합니다.

중요: 여기에 열거형을 추가할 때 권한 개체에 대한 getter 및 setter를 사용하여 permissionOptions.cs 업데이트해야 합니다. 데이터베이스 및 개체 권한을 추가할 때도 DatabasePrincipal.cs ContainsPermissionType 메서드를 업데이트해야 합니다. 이러한 함수에 사용되는 DatabasePermissionType 열거형은 SqlParser에서 파생됩니다.

public enum DatabasePermissionSetValue

type DatabasePermissionSetValue = 

Public Enum DatabasePermissionSetValue

상속

Enum

DatabasePermissionSetValue

필드

Name	값	Description
Alter	0
AlterAnyAsymmetricKey	1
AlterAnyApplicationRole	2
AlterAnyAssembly	3
AlterAnyCertificate	4
AlterAnyDataspace	5
AlterAnyDatabaseEventNotification	6
AlterAnyFulltextCatalog	7
AlterAnyMessageType	8
AlterAnyRole	9
AlterAnyRoute	10
AlterAnyRemoteServiceBinding	11
AlterAnyContract	12
AlterAnySymmetricKey	13
AlterAnySchema	14
AlterAnyService	15
AlterAnyDatabaseDdlTrigger	16
AlterAnyUser	17
Authenticate	18
BackupDatabase	19
BackupLog	20
Control	21
Connect	22
ConnectReplication	23
Checkpoint	24
CreateAggregate	25
CreateAsymmetricKey	26
CreateAssembly	27
CreateCertificate	28
CreateDatabase	29
CreateDefault	30
CreateDatabaseDdlEventNotification	31
CreateFunction	32
CreateFulltextCatalog	33
CreateMessageType	34
CreateProcedure	35
CreateQueue	36
CreateRole	37
CreateRoute	38
CreateRule	39
CreateRemoteServiceBinding	40
CreateContract	41
CreateSymmetricKey	42
CreateSchema	43
CreateSynonym	44
CreateService	45
CreateTable	46
CreateType	47
CreateView	48
CreateXmlSchemaCollection	49
Delete	50
Execute	51
Insert	52
References	53
Select	54
Showplan	55
SubscribeQueryNotifications	56
TakeOwnership	57
Update	58
ViewDefinition	59
ViewDatabaseState	60
AlterAnyDatabaseAudit	61
AlterAnySecurityPolicy	62
AlterAnyExternalDataSource	63
AlterAnyExternalFileFormat	64
AlterAnyMask	65
Unmask	66
ViewAnyColumnEncryptionKeyDefinition	67
ViewAnyColumnMasterKeyDefinition	68
AlterAnyDatabaseEventSession	69
AlterAnyColumnEncryptionKey	70
AlterAnyColumnMasterKey	71
AlterAnyDatabaseScopedConfiguration	72
AlterAnyExternalLibrary	73
AdministerDatabaseBulkOperations	74
ExecuteAnyExternalScript	75
KillDatabaseConnection	76
CreateExternalLibrary	77
AlterAnySensitivityClassification	78
ViewAnySensitivityClassification	79
AlterAnyExternalLanguage	80
CreateExternalLanguage	81
AlterAnyExternalStream	82
AlterAnyExternalJob	83
OwnershipChaining	84
CreateUser	85
ViewDatabaseSecurityState	86
ViewDatabasePerformanceState	87
ViewSecurityDefinition	88
ViewCryptographicallySecuredDefinition	89
EnableLedger	90
AlterLedger	91
ViewLedgerContent	92
ExecuteAnyExternalEndpoint	93
CreateAnyDatabaseEventSession	94
DropAnyDatabaseEventSession	95
AlterAnyDatabaseEventSessionOption	96
AlterAnyDatabaseEventSessionAddEvent	97
AlterAnyDatabaseEventSessionDropEvent	98
AlterAnyDatabaseEventSessionEnable	99
AlterAnyDatabaseEventSessionDisable	100
AlterAnyDatabaseEventSessionAddTarget	101
AlterAnyDatabaseEventSessionDropTarget	102
ViewPerformanceDefinition	103
ViewDatabaseSecurityAudit	104
AlterLedgerConfiguration	105
AlterAnyExternalMirror	106