PermissionType Enumeration

 

Updated: April 20, 2017

Sql permissions

Namespace:   Microsoft.SqlServer.Dac.Model
Assembly:  Microsoft.SqlServer.Dac.Extensions (in Microsoft.SqlServer.Dac.Extensions.dll)

public enum PermissionType

Member nameDescription
AdministerBulkOperations

AdministerBulkOperations

All

All

Alter

Alter

AlterAnyApplicationRole

AlterAnyApplicationRole

AlterAnyAssembly

AlterAnyAssembly

AlterAnyAsymmetricKey

AlterAnyAsymmetricKey

AlterAnyAvailabilityGroup

AlterAnyAvailabilityGroup

AlterAnyCertificate

AlterAnyCertificate

AlterAnyColumnEncryptionKey

AlterAnyColumnMasterKey

AlterAnyConnection

AlterAnyConnection

AlterAnyContract

AlterAnyContract

AlterAnyCredential

AlterAnyCredential

AlterAnyDatabase

AlterAnyDatabase

AlterAnyDatabaseAudit

AlterAnyDatabaseAudit

AlterAnyDatabaseDdlTrigger

AlterAnyDatabaseDdlTrigger

AlterAnyDatabaseEventNotification

AlterAnyDatabaseEventNotification

AlterAnyDatabaseEventSession

AlterAnyDatabaseEventSession

AlterAnyDataspace

AlterAnyDataspace

AlterAnyEndpoint

AlterAnyEndpoint

AlterAnyEventNotification

AlterAnyEventNotification

AlterAnyExternalDataSource

AlterAnyExternalFileFormat

AlterAnyFulltextCatalog

AlterAnyFulltextCatalog

AlterAnyLinkedServer

AlterAnyLinkedServer

AlterAnyLogin

AlterAnyLogin

AlterAnyMask

AlterAnyMessageType

AlterAnyMessageType

AlterAnyRemoteServiceBinding

AlterAnyRemoteServiceBinding

AlterAnyRole

AlterAnyRole

AlterAnyRoute

AlterAnyRoute

AlterAnySchema

AlterAnySchema

AlterAnySecurityPolicy

AlterAnyServerAudit

AlterAnyServerAudit

AlterAnyServerRole

AlterAnyServerRole

AlterAnyService

AlterAnyService

AlterAnySymmetricKey

AlterAnySymmetricKey

AlterAnyUser

AlterAnyUser

AlterResources

AlterResources

AlterServerState

AlterServerState

AlterSettings

AlterSettings

AlterTrace

AlterTrace

Authenticate

Authenticate

AuthenticateServer

AuthenticateServer

BackupDatabase

BackupDatabase

BackupLog

BackupLog

Checkpoint

Checkpoint

Connect

Connect

ConnectAnyDatabase

ConnectAnyDatabase

ConnectReplication

ConnectReplication

ConnectSql

ConnectSql

Control

Control

ControlServer

ControlServer

CreateAggregate

CreateAggregate

CreateAnyDatabase

CreateAnyDatabase

CreateAssembly

CreateAssembly

CreateAsymmetricKey

CreateAsymmetricKey

CreateAvailabilityGroup

CreateAvailabilityGroup

CreateCertificate

CreateCertificate

CreateContract

CreateContract

CreateDatabase

CreateDatabase

CreateDatabaseDdlEventNotification

CreateDatabaseDdlEventNotification

CreateDdlEventNotification

CreateDdlEventNotification

CreateDefault

CreateDefault

CreateEndpoint

CreateEndpoint

CreateFulltextCatalog

CreateFulltextCatalog

CreateFunction

CreateFunction

CreateMessageType

CreateMessageType

CreateProcedure

CreateProcedure

CreateQueue

CreateQueue

CreateRemoteServiceBinding

CreateRemoteServiceBinding

CreateRole

CreateRole

CreateRoute

CreateRoute

CreateRule

CreateRule

CreateSchema

CreateSchema

CreateSequence

CreateSequence

CreateServerRole

CreateServerRole

CreateService

CreateService

CreateSymmetricKey

CreateSymmetricKey

CreateSynonym

CreateSynonym

CreateTable

CreateTable

CreateTraceEventNotification

CreateTraceEventNotification

CreateType

CreateType

CreateView

CreateView

CreateXmlSchemaCollection

CreateXmlSchemaCollection

Delete

Delete

Execute

Execute

ExternalAccessAssembly

ExternalAccessAssembly

Impersonate

Impersonate

ImpersonateAnyLogin

ImpersonateAnyLogin

Insert

Insert

Receive

Receive

References

References

Select

Select

SelectAllUserSecurables

SelectAllUserSecurables

Send

Send

Showplan

Showplan

Shutdown

Shutdown

SubscribeQueryNotifications

SubscribeQueryNotifications

TakeOwnership

TakeOwnership

Unknown

Unknown

Unmask

UnsafeAssembly

UnsafeAssembly

Update

Update

ViewAnyColumnEncryptionKeyDefinition

ViewAnyColumnMasterKeyDefinition

ViewAnyDatabase

ViewAnyDatabase

ViewAnyDefinition

ViewAnyDefinition

ViewChangeTracking

ViewChangeTracking

ViewDatabaseState

ViewDatabaseState

ViewDefinition

ViewDefinition

ViewServerState

ViewServerState

Return to top

Community Additions

ADD
Show: