DatabasePermissionSetValue DatabasePermissionSetValue DatabasePermissionSetValue Enum

Definition

The DatabasePermissionSetValue enumeration is a list of constant values that specify all the database permissions.

public enum class DatabasePermissionSetValue
public enum DatabasePermissionSetValue
Public Enum DatabasePermissionSetValue
Inheritance
DatabasePermissionSetValueDatabasePermissionSetValueDatabasePermissionSetValue

Fields

Alter Alter Alter 0

The ability to alter the database.

AlterAnyApplicationRole AlterAnyApplicationRole AlterAnyApplicationRole 2

The ability to alter any application role that belongs to the database.

AlterAnyAssembly AlterAnyAssembly AlterAnyAssembly 3

The ability to alter any assembly that belongs to the database.

AlterAnyAsymmetricKey AlterAnyAsymmetricKey AlterAnyAsymmetricKey 1

The ability to alter any asymmetric key that belongs to the database.

AlterAnyCertificate AlterAnyCertificate AlterAnyCertificate 4

The ability to alter any certificate that belongs to the database.

AlterAnyContract AlterAnyContract AlterAnyContract 12

The ability to alter any contract that belongs to the database.

AlterAnyDatabaseAudit AlterAnyDatabaseAudit AlterAnyDatabaseAudit 61

The ability to alter any database audit that belongs to the database.

AlterAnyDatabaseDdlTrigger AlterAnyDatabaseDdlTrigger AlterAnyDatabaseDdlTrigger 16

The ability to alter any database data definition language (DDL) trigger that belongs to the database.

AlterAnyDatabaseEventNotification AlterAnyDatabaseEventNotification AlterAnyDatabaseEventNotification 6

The ability to alter any database event notification that belongs to the database.

AlterAnyDataspace AlterAnyDataspace AlterAnyDataspace 5

The ability to alter any dataspace that belongs to the database.

AlterAnyExternalDataSource AlterAnyExternalDataSource AlterAnyExternalDataSource 63

The ability to alter any external data source that belongs to the database.

AlterAnyExternalFileFormat AlterAnyExternalFileFormat AlterAnyExternalFileFormat 64

The ability to alter any external file format that belongs to the database.

AlterAnyFulltextCatalog AlterAnyFulltextCatalog AlterAnyFulltextCatalog 7

The ability to alter any full-text catalog that belongs to the database.

AlterAnyMessageType AlterAnyMessageType AlterAnyMessageType 8

The ability to alter any message type that belongs to the database.

AlterAnyRemoteServiceBinding AlterAnyRemoteServiceBinding AlterAnyRemoteServiceBinding 11

The ability to alter any remote service binding that belongs to the database.

AlterAnyRole AlterAnyRole AlterAnyRole 9

The ability to alter any role that belongs to the database.

AlterAnyRoute AlterAnyRoute AlterAnyRoute 10

The ability to alter any route that belongs to the database.

AlterAnySchema AlterAnySchema AlterAnySchema 14

The ability to alter any schema that belongs to the database.

AlterAnySecurityPolicy AlterAnySecurityPolicy AlterAnySecurityPolicy 62

The ability to alter any security policy that belongs to the datatbase.

AlterAnyService AlterAnyService AlterAnyService 15

The ability to alter any service that belongs to the database.

AlterAnySymmetricKey AlterAnySymmetricKey AlterAnySymmetricKey 13

The ability to alter any symmetric key that belongs to the database.

AlterAnyUser AlterAnyUser AlterAnyUser 17

The ability to alter any user that belongs to the database.

Authenticate Authenticate Authenticate 18

The ability to authenticate database users.

BackupDatabase BackupDatabase BackupDatabase 19

The ability to back up the database.

BackupLog BackupLog BackupLog 20

The ability to back up the database log.

Checkpoint Checkpoint Checkpoint 24

The ability to issue a checkpoint.

Connect Connect Connect 22

The ability to connect to the database.

ConnectReplication ConnectReplication ConnectReplication 23

The ability to connect to a replication server.

Control Control Control 21

The ability to control the database.

CreateAggregate CreateAggregate CreateAggregate 25

The ability to create an aggregate in the database.

CreateAssembly CreateAssembly CreateAssembly 27

The ability to create an assembly in the database.

CreateAsymmetricKey CreateAsymmetricKey CreateAsymmetricKey 26

The ability to create an asymmetric key in the database.

CreateCertificate CreateCertificate CreateCertificate 28

The ability to create a certificate in the database.

CreateContract CreateContract CreateContract 41

The ability to create a contract in the database.

CreateDatabase CreateDatabase CreateDatabase 29

The ability to create the database.

CreateDatabaseDdlEventNotification CreateDatabaseDdlEventNotification CreateDatabaseDdlEventNotification 31

The ability to create a database data definition language (DDL) event notification.

CreateDefault CreateDefault CreateDefault 30

The ability to create a default in the database.

CreateFulltextCatalog CreateFulltextCatalog CreateFulltextCatalog 33

The ability to create a full-text catalog in the database.

CreateFunction CreateFunction CreateFunction 32

The ability to create a function in the database.

CreateMessageType CreateMessageType CreateMessageType 34

The ability to create a message type in the database.

CreateProcedure CreateProcedure CreateProcedure 35

The ability to create a stored procedure in the database.

CreateQueue CreateQueue CreateQueue 36

The ability to create a queue in the database.

CreateRemoteServiceBinding CreateRemoteServiceBinding CreateRemoteServiceBinding 40

The ability to create a remote service binding in the database.

CreateRole CreateRole CreateRole 37

The ability to create a role in the database.

CreateRoute CreateRoute CreateRoute 38

The ability to create a route in the database.

CreateRule CreateRule CreateRule 39

The ability to create a rule in the database.

CreateSchema CreateSchema CreateSchema 43

The ability to create a schema in the database.

CreateService CreateService CreateService 45

The ability to create a service in the database.

CreateSymmetricKey CreateSymmetricKey CreateSymmetricKey 42

The ability to create a symmetric key in the database.

CreateSynonym CreateSynonym CreateSynonym 44

The ability to create a synonym in the database.

CreateTable CreateTable CreateTable 46

The ability to create a table in the database.

CreateType CreateType CreateType 47

The ability to create a type in the database.

CreateView CreateView CreateView 48

The ability to create a view in the database.

CreateXmlSchemaCollection CreateXmlSchemaCollection CreateXmlSchemaCollection 49

The ability to create an XML schema collection in the database.

Delete Delete Delete 50

The ability delete the database.

Execute Execute Execute 51

The ability to execute a procedure in the database.

Insert Insert Insert 52

The ability to insert data into the database.

References References References 53

The ability to alter perform references in the database.

Select Select Select 54

The ability to select data in the database.

Showplan Showplan Showplan 55

The ability to run showplan.

SubscribeQueryNotifications SubscribeQueryNotifications SubscribeQueryNotifications 56

The ability to subscribe to query notifications.

TakeOwnership TakeOwnership TakeOwnership 57

The ability to take ownership of the database.

Update Update Update 58

The ability to update data in the database.

ViewDatabaseState ViewDatabaseState ViewDatabaseState 60

The ability to view the state of the database.

ViewDefinition ViewDefinition ViewDefinition 59

The ability to view definition information on the database.

Applies to