DatabasePermissionSetValue Enumeration

 

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

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)

public enum DatabasePermissionSetValue

Member nameDescription
Alter

The ability to alter the database.

AlterAnyApplicationRole

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

AlterAnyAssembly

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

AlterAnyAsymmetricKey

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

AlterAnyCertificate

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

AlterAnyContract

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

AlterAnyDatabaseAudit

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

AlterAnyDatabaseDdlTrigger

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

AlterAnyDatabaseEventNotification

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

AlterAnyDataspace

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

AlterAnyExternalDataSource

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

AlterAnyExternalFileFormat

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

AlterAnyFulltextCatalog

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

AlterAnyMessageType

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

AlterAnyRemoteServiceBinding

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

AlterAnyRole

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

AlterAnyRoute

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

AlterAnySchema

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

AlterAnySecurityPolicy

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

AlterAnyService

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

AlterAnySymmetricKey

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

AlterAnyUser

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

Authenticate

The ability to authenticate database users.

BackupDatabase

The ability to back up the database.

BackupLog

The ability to back up the database log.

Checkpoint

The ability to issue a checkpoint.

Connect

The ability to connect to the database.

ConnectReplication

The ability to connect to a replication server.

Control

The ability to control the database.

CreateAggregate

The ability to create an aggregate in the database.

CreateAssembly

The ability to create an assembly in the database.

CreateAsymmetricKey

The ability to create an asymmetric key in the database.

CreateCertificate

The ability to create a certificate in the database.

CreateContract

The ability to create a contract in the database.

CreateDatabase

The ability to create the database.

CreateDatabaseDdlEventNotification

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

CreateDefault

The ability to create a default in the database.

CreateFulltextCatalog

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

CreateFunction

The ability to create a function in the database.

CreateMessageType

The ability to create a message type in the database.

CreateProcedure

The ability to create a stored procedure in the database.

CreateQueue

The ability to create a queue in the database.

CreateRemoteServiceBinding

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

CreateRole

The ability to create a role in the database.

CreateRoute

The ability to create a route in the database.

CreateRule

The ability to create a rule in the database.

CreateSchema

The ability to create a schema in the database.

CreateService

The ability to create a service in the database.

CreateSymmetricKey

The ability to create a symmetric key in the database.

CreateSynonym

The ability to create a synonym in the database.

CreateTable

The ability to create a table in the database.

CreateType

The ability to create a type in the database.

CreateView

The ability to create a view in the database.

CreateXmlSchemaCollection

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

Delete

The ability delete the database.

Execute

The ability to execute a procedure in the database.

Insert

The ability to insert data into the database.

References

The ability to alter perform references in the database.

Select

The ability to select data in the database.

Showplan

The ability to run showplan.

SubscribeQueryNotifications

The ability to subscribe to query notifications.

TakeOwnership

The ability to take ownership of the database.

Update

The ability to update data in the database.

ViewDatabaseState

The ability to view the state of the database.

ViewDefinition

The ability to view definition information on the database.

Return to top
Show: