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)

Syntax

'Declaration
Public Enumeration DatabasePermissionType
'Usage
Dim instance As DatabasePermissionType

public enum DatabasePermissionType

public enum class DatabasePermissionType

type DatabasePermissionType

public enum DatabasePermissionType

Members

	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.

See Also

Reference

Microsoft.SqlServer.Management.SqlParser.Metadata Namespace