SqlPermission Enumeration
Models permissions for SQL Server. For each value, indicates that the principal has the specified permission. For example, Insert indicates that the principal has INSERT permission.
Namespace: Microsoft.Data.Schema.Sql.SchemaModel
Assembly: Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)
Syntax
'Declaration
Public Enumeration SqlPermission
public enum SqlPermission
public enum class SqlPermission
type SqlPermission
public enum SqlPermission
Members
| Member name | Description | |
|---|---|---|
| Unknown | Indicates that the permission type is unknown. | |
| Insert | Specifies the INSERT permission. | |
| Select | Specifies the SELECT permission. | |
| Update | Specifies the UPDATE permission. | |
| Delete | Specifies the DELETE permission. | |
| References | Specifies the REFERENCES permission. | |
| CreateDatabase | Specifies the CREATE DATABASE permission. | |
| CreateDefault | Specifies the CREATE DEFAULT permission. | |
| CreateFunction | Specifies the CREATE FUNCTION permission. | |
| CreateProcedure | Specifies the CREATE PROCEDURE permission. | |
| CreateRule | Specifies the CREATE RULE permission. | |
| CreateTable | Specifies the CREATE TABLE permission. | |
| CreateView | Specifies the CREATE VIEW permission. | |
| BackupDatabase | Specifies the BACKUP DATABASE permission. | |
| BackupLog | Specifies the BACKUP LOG permission. | |
| AdministerBulkOperations | Specifies the ADMINISTER BULK OPERATIONS permission. | |
| Alter | Specifies the ALTER permission. | |
| AlterAnyApplicationRole | Specifies the ALTER ANY APPLICATION ROLE permission. | |
| AlterAnyAssembly | Specifies the ALTER ANY ASSEMBLY permission. | |
| AlterAnyAsymmetricKey | Specifies the ALTER ANY ASYMMETRIC KEY permission. | |
| AlterAnyCertificate | Specifies the ALTER ANY CERTIFICATE permission. | |
| AlterAnyConnection | Specifies the ALTER ANY CONNECTION permission. | |
| AlterAnyContract | Specifies the ALTER ANY CONTRACT permission. | |
| AlterAnyCredential | Specifies the ALTER ANY CREDENTIAL permission. | |
| AlterAnyDatabase | Specifies the ALTER ANY DATABASE permission. | |
| AlterAnyDatabaseDdlTrigger | Specifies the ALTER ANY DATABASE DDL TRIGGER permission. | |
| AlterAnyDatabaseEventNotification | Specifies the ALTER ANY DATABASE EVENT NOTIFICATION permission. | |
| AlterAnyDataspace | Specifies the ALTER ANY DATASPACE permission. | |
| AlterAnyEndpoint | Specifies the ALTER ANY ENDPOINT permission. | |
| AlterAnyEventNotification | Specifies the ALTER ANY EVENT NOTIFICATION permission. | |
| AlterAnyFulltextCatalog | Specifies the ALTER ANY FULLTEXT CATALOG permission. | |
| AlterAnyLinkedServer | Specifies the ALTER ANY LINKED SERVER permission. | |
| AlterAnyLogin | Specifies the ALTER ANY LOGIN permission. | |
| AlterAnyMessageType | Specifies the ALTER ANY MESSAGE TYPE permission. | |
| AlterAnyRemoteServiceBinding | Specifies the ALTER ANY REMOTE SERVICE BINDING permission. | |
| AlterAnyRole | Specifies the ALTER ANY ROLE permission. | |
| AlterAnyRoute | Specifies the ALTER ANY ROUTE permission. | |
| AlterAnySchema | Specifies the ALTER ANY SCHEMA permission. | |
| AlterAnyService | Specifies the ALTER ANY SERVICE permission. | |
| AlterAnySymmetricKey | Specifies the ALTER ANY SYMMETRIC KEY permission. | |
| AlterAnyUser | Specifies the ALTER ANY USER permission. | |
| AlterResources | Specifies the ALTER RESOURCE permission. | |
| AlterServerState | Specifies the ALTER SERVER STATE permission. | |
| AlterSettings | Specifies the ALTER SETTINGS permission. | |
| AlterTrace | Specifies the ALTER TRACE permission. | |
| Authenticate | Specifies the AUTHENTICATE permission. | |
| AuthenticateServer | Specifies the AUTHENTICATE SERVER permission. | |
| Checkpoint | Specifies the CHECKPOINT permission. | |
| Connect | Specifies the CONNECT permission. | |
| ConnectReplication | Specifies the CONNECT REPLICATION permission. | |
| ConnectSql | Specifies the CONNECT SQL permission. | |
| Control | Specifies the CONTROL permission. | |
| ControlServer | Specifies the CONTROL SERVER permission. | |
| CreateAggregate | Specifies the CREATE AGGREGATE permission. | |
| CreateAnyDatabase | Specifies the CREATE ANY DATABASE permission. | |
| CreateAssembly | Specifies the CREATE ASSEMBLY permission. | |
| CreateAsymmetricKey | Specifies the CREATE ASYMMETRIC KEY permission. | |
| CreateCertificate | Specifies the CREATE CERTIFICATE permission. | |
| CreateContract | Specifies the CREATE CONTRACT permission. | |
| CreateDatabaseDdlEventNotification | Specifies the CREATE DATABASE DDL EVENT NOTIFICATION permission. | |
| CreateDdlEventNotification | Specifies the CREATE DDL EVENT NOTIFICATION permission. | |
| CreateEndpoint | Specifies the CREATE ENDPOINT permission. | |
| CreateFulltextCatalog | Specifies the CREATE FULLTEXT CATALOG permission. | |
| CreateMessageType | Specifies the CREATE MESSAGE TYPE permission. | |
| CreateQueue | Specifies the CREATE QUEUE permission. | |
| CreateRemoteServiceBinding | Specifies the CREATE REMOTE SERVICE BINDING permission. | |
| CreateRole | Specifies the CREATE ROLE permission. | |
| CreateRoute | Specifies the CREATE ROUTE permission. | |
| CreateSchema | Specifies the CREATE SCHEMA permission. | |
| CreateService | Specifies the CREATE SERVICE permission. | |
| CreateSymmetricKey | Specifies the CREATE SYMMETRIC KEY permission. | |
| CreateSynonym | Specifies the CREATE SYNONYM permission. | |
| CreateTraceEventNotification | Specifies the CREATE TRACE EVENT NOTIFICATION permission. | |
| CreateType | Specifies the CREATE TYPE permission. | |
| CreateXmlSchemaCollection | Specifies the CREATE XML SCHEMA COLLECTION permission. | |
| Execute | Specifies the EXECUTE permission. | |
| ExternalAccessAssembly | Specifies the EXTERNAL ACCESS ASSEMBLY permission. | |
| Impersonate | Specifies the IMPERSONATE permission. | |
| Receive | Specifies the RECEIVE permission. | |
| Send | Specifies the SEND permission. | |
| Showplan | Specifies the SHOWPLAN permission. | |
| Shutdown | Specifies the SHUTDOWN permission. | |
| SubscribeQueryNotifications | Specifies the SUBSCRIBE QUERY NOTIFICATION permission. | |
| TakeOwnership | Specifies the TAKE OWNERSHIP permission. | |
| UnsafeAssembly | Specifies the UNSAFE ASSEMBLY permission. | |
| ViewAnyDatabase | Specifies the VIEW ANY DATABASE permission. | |
| ViewAnyDefinition | Specifies the VIEW ANY DEFINITION permission. | |
| ViewChangeTracking | Specifies the VIEW CHANGE TRACKING permission. | |
| ViewDatabaseState | Specifies the VIEW DATABASE STATE permission. | |
| ViewDefinition | Specifies the VIEW DEFINITION permission. | |
| ViewServerState | Specifies the VIEW SERVER STATE permission. | |
| All | Specifies ALL permissions. | |
| AlterAnyDatabaseAudit | Specifies the ALTER ANY DATABASE AUDIT permission. | |
| AlterAnyServerAudit | Specifies the ALTER ANY SERVER AUDIT permission. |