DatabasePermissionType Enumeration

 

Specifies the SQL Server database permission types.

Namespace:   Microsoft.SqlServer.Management.SqlParser.Metadata
Assembly:  Microsoft.SqlServer.Management.SqlParser (in Microsoft.SqlServer.Management.SqlParser.dll)

public enum DatabasePermissionType

Member nameDescription
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.

Return to top
Show: