Share via

SqlPermission Enumeration

  • Article

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.

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace