DatabasePermissionSetValue 列舉
The DatabasePermissionSetValue enumeration is a list of constant values that specify all the database permissions.
命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.SqlEnum (在 Microsoft.SqlServer.SqlEnum.dll 中)
語法
'宣告
Public Enumeration DatabasePermissionSetValue
'用途
Dim instance As DatabasePermissionSetValue
public enum DatabasePermissionSetValue
public enum class DatabasePermissionSetValue
type DatabasePermissionSetValue
public enum DatabasePermissionSetValue
成員
| 成員名稱 | 說明 | |
|---|---|---|
| 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. |