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
Elemente
| Elementname | Beschreibung | |
|---|---|---|
| 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. |