DatabasePermissionType Enumeration
Specifies the SQL Server database permission types.
Assembly: Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)
| Member name | Description | |
|---|---|---|
| Alter | An ALTER permission. | |
| AlterAnyApplicationRole | An ALTER ANY APPLICATION ROLE permission. | |
| AlterAnyAssembly | An ALTER ANY ASSEMBLY permission. | |
| AlterAnyAsymmetricKey | An ALTER ANY ASYMMETRIC KEY permission. | |
| AlterAnyCertificate | An ALTER ANY CERTIFICATE permission. | |
| AlterAnyContract | An ALTER ANY CONTRACT permission. | |
| AlterAnyDatabaseAudit | An ALTER ANY DATABASE AUDIT permission. | |
| AlterAnyDatabaseDdlTrigger | An ALTER ANY DATABASE DDL TRIGGER permission. | |
| AlterAnyDatabaseEventNotification | An ALTER ANY DATABASE EVENT NOTIFICATION permission. | |
| AlterAnyDataspace | An ALTER ANY DATASPACE permission. | |
| AlterAnyFulltextCatalog | An ALTER ANY FULLTEXT CATALOG permission. | |
| AlterAnyMessageType | An ALTER ANY MESSAGE TYPE permission. | |
| AlterAnyRemoteServiceBinding | An ALTER ANY REMOTE SERVICE BINDING permission. | |
| AlterAnyRole | An ALTER ANY ROLE permission. | |
| AlterAnyRoute | An ALTER ANY ROUTE permission. | |
| AlterAnySchema | An ALTER ANY SCHEMA permission. | |
| AlterAnyService | An ALTER ANY SERVICE permission. | |
| AlterAnySymmetricKey | An ALTER ANY SYMMETRIC KEY permission. | |
| AlterAnyUser | An ALTER ANY USER permission. | |
| Authenticate | An AUTHENTICATE permission. | |
| BackupDatabase | A BACKUP DATABASE permission. | |
| BackupLog | A BACKUP LOG permission. | |
| Checkpoint | A CHECKPOINT permission. | |
| Connect | A CONNECT permission. | |
| ConnectReplication | A CONNECT REPLICATION permission. | |
| Control | A CONTROL permission. | |
| CreateAggregate | A CREATE AGGREGATE permission. | |
| CreateAssembly | A CREATE ASSEMBLY permission. | |
| CreateAsymmetricKey | A CREATE ASYMMETRIC KEY permission. | |
| CreateCertificate | A CREATE CERTIFICATE permission. | |
| CreateContract | A CREATE CONTRACT permission. | |
| CreateDatabase | A CREATE DATABASE permission. | |
| CreateDatabaseDdlEventNotification | A CREATE DATABASE DDL EVENT NOTIFICATION permission. | |
| CreateDefault | A CREATE DEFAULT permission. | |
| CreateFulltextCatalog | A CREATE FULLTEXT CATALOG permission. | |
| CreateFunction | A CREATE FUNCTION permission. | |
| CreateMessageType | A CREATE MESSAGE TYPE permission. | |
| CreateProcedure | A CREATE PROCEDURE permission. | |
| CreateQueue | A CREATE QUEUE permission. | |
| CreateRemoteServiceBinding | A CREATE REMOTE SERVICE BINDING permission. | |
| CreateRole | A CREATE ROLE permission. | |
| CreateRoute | A CREATE ROUTE permission. | |
| CreateRule | A CREATE RULE permission. | |
| CreateSchema | A CREATE SCHEMA permission. | |
| CreateService | A CREATE SERVICE permission. | |
| CreateSymmetricKey | A CREATE SYMMETRIC KEY permission. | |
| CreateSynonym | A CREATE SYNONYM permission. | |
| CreateTable | A CREATE TABLE permission. | |
| CreateType | A CREATE TYPE permission. | |
| CreateView | A CREATE VIEW permission. | |
| CreateXmlSchemaCollection | A CREATE XML SCHEMA COLLECTION permission. | |
| Delete | A DELETE permission. | |
| Execute | An EXECUTE permission. | |
| Impersonate | An IMPERSONATE permission. | |
| Insert | An INSERT permission. | |
| Receive | A RECEIVE permission. | |
| References | A REFERENCES permission. | |
| Select | A SELECT permission. | |
| Send | A SEND permission. | |
| Showplan | A SHOWPLAN permission. | |
| SubscribeQueryNotifications | A SUBSCRIBE QUERY NOTIFICATIONS permission. | |
| TakeOwnership | A TAKE OWNERSHIP permission. | |
| Update | An UPDATE permission. | |
| ViewChangeTracking | A VIEW CHANGE TRACKING permission. | |
| ViewDatabaseState | A VIEW DATABASE STATE permission. | |
| ViewDefinition | A VIEW DEFINITION permission. |