Sdílet prostřednictvím

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

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

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

Fields

AdministerDatabaseBulkOperations 74
Alter 0
AlterAnyApplicationRole 2
AlterAnyAssembly 3
AlterAnyAsymmetricKey 1
AlterAnyCertificate 4
AlterAnyColumnEncryptionKey 70
AlterAnyColumnMasterKey 71
AlterAnyContract 12
AlterAnyDatabaseAudit 61
AlterAnyDatabaseDdlTrigger 16
AlterAnyDatabaseEventNotification 6
AlterAnyDatabaseEventSession 69
AlterAnyDatabaseScopedConfiguration 72
AlterAnyDataspace 5
AlterAnyExternalDataSource 63
AlterAnyExternalFileFormat 64
AlterAnyExternalLibrary 73
AlterAnyFulltextCatalog 7
AlterAnyMask 65
AlterAnyMessageType 8
AlterAnyRemoteServiceBinding 11
AlterAnyRole 9
AlterAnyRoute 10
AlterAnySchema 14
AlterAnySecurityPolicy 62
AlterAnySensitivityClassification 78
AlterAnyService 15
AlterAnySymmetricKey 13
AlterAnyUser 17
Authenticate 18
BackupDatabase 19
BackupLog 20
Checkpoint 24
Connect 22
ConnectReplication 23
Control 21
CreateAggregate 25
CreateAssembly 27
CreateAsymmetricKey 26
CreateCertificate 28
CreateContract 41
CreateDatabase 29
CreateDatabaseDdlEventNotification 31
CreateDefault 30
CreateExternalLibrary 77
CreateFulltextCatalog 33
CreateFunction 32
CreateMessageType 34
CreateProcedure 35
CreateQueue 36
CreateRemoteServiceBinding 40
CreateRole 37
CreateRoute 38
CreateRule 39
CreateSchema 43
CreateService 45
CreateSymmetricKey 42
CreateSynonym 44
CreateTable 46
CreateType 47
CreateView 48
CreateXmlSchemaCollection 49
Delete 50
Execute 51
ExecuteAnyExternalScript 75
Insert 52
KillDatabaseConnection 76
References 53
Select 54
Showplan 55
SubscribeQueryNotifications 56
TakeOwnership 57
Unmask 66
Update 58
ViewAnyColumnEncryptionKeyDefinition 67
ViewAnyColumnMasterKeyDefinition 68
ViewAnySensitivityClassification 79
ViewDatabaseState 60
ViewDefinition 59

Applies to