Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
public enum DatabasePermissionSetValue
public enum class DatabasePermissionSetValue
public enum DatabasePermissionSetValue
public enum DatabasePermissionSetValue
Members
| Member name | Description |
|---|---|
| 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. |
| 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. |
| 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. |
| 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. |
Remarks
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.