Partilhar 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

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

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

Applies to