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)

Syntax

'Declaration
Public Enumeration DatabasePermissionSetValue
'Usage
Dim instance As DatabasePermissionSetValue
public enum DatabasePermissionSetValue
public enum class DatabasePermissionSetValue
type DatabasePermissionSetValue
public enum DatabasePermissionSetValue

Members

Member name Description
Alter The ability to alter the database.
AlterAnyAsymmetricKey The ability to alter any asymmetric key that belongs to 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.
AlterAnyCertificate The ability to alter any certificate that belongs to the database.
AlterAnyDatabaseAudit The ability to alter any database audit that belongs to the database.
AlterAnyDataspace The ability to alter any dataspace that belongs to the database.
AlterAnyDatabaseEventNotification The ability to alter any database event notification 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.
AlterAnyRole The ability to alter any role that belongs to the database.
AlterAnyRoute The ability to alter any route that belongs to the database.
AlterAnyRemoteServiceBinding The ability to alter any remote service binding that belongs to the database.
AlterAnyContract The ability to alter any contract that belongs to the database.
AlterAnySymmetricKey The ability to alter any symmetric key that belongs to the database.
AlterAnySchema The ability to alter any schema that belongs to the database.
AlterAnyService The ability to alter any service that belongs to the database.
AlterAnyDatabaseDdlTrigger The ability to alter any database data definition language (DDL) trigger 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.
Control The ability to control the database.
Connect The ability to connect to the database.
ConnectReplication The ability to connect to a replication server.
Checkpoint The ability to issue a checkpoint.
CreateAggregate The ability to create an aggregate in the database.
CreateAsymmetricKey The ability to create an asymmetric key in the database.
CreateAssembly The ability to create an assembly in the database.
CreateCertificate The ability to create a certificate in the database.
CreateDatabase The ability to create the database.
CreateDefault The ability to create a default in the database.
CreateDatabaseDdlEventNotification The ability to create a database data definition language (DDL) event notification.
CreateFunction The ability to create a function in the database.
CreateFulltextCatalog The ability to create a full-text catalog 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.
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.
CreateRemoteServiceBinding The ability to create a remote service binding in the database.
CreateContract The ability to create a contract in the database.
CreateSymmetricKey The ability to create a symmetric key in the database.
CreateSchema The ability to create a schema in the database.
CreateSynonym The ability to create a synonym in the database.
CreateService The ability to create a service 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.
ViewDefinition The ability to view definition information on the database.
ViewDatabaseState The ability to view the state of the database.