Share via

DatabasePermissionSetValue Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Smo
Assembly:
Microsoft.SqlServer.SqlEnum.dll
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0
Package:
Microsoft.SqlServer.SqlManagementObjects v172.64.0

Enum containing all possible DatabasePermissions use sys.fn_builtin_permissions to see the latest values on new versions of SQL

IMPORTANT: When adding enums here, you must also update permissionOptions.cs with the getters and setters for the permission objects. The ContainsPermissionType methods in DatabasePrincipal.cs must also be updated when adding database and object permissions. The DatabasePermissionType enum used in those functions are derived from SqlParser.

public enum DatabasePermissionSetValue
type DatabasePermissionSetValue = 
Public Enum DatabasePermissionSetValue
Inheritance
Enum
DatabasePermissionSetValue

Fields

Name Value 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

Applies to