Export (0) Print
Expand All
Expand Minimize

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
AlterAn ALTER permission.
AlterAnyApplicationRoleAn ALTER ANY APPLICATION ROLE permission.
AlterAnyAssemblyAn ALTER ANY ASSEMBLY permission.
AlterAnyAsymmetricKeyAn ALTER ANY ASYMMETRIC KEY permission.
AlterAnyCertificateAn ALTER ANY CERTIFICATE permission.
AlterAnyContractAn ALTER ANY CONTRACT permission.
AlterAnyDatabaseAuditAn ALTER ANY DATABASE AUDIT permission.
AlterAnyDatabaseDdlTriggerAn ALTER ANY DATABASE DDL TRIGGER permission.
AlterAnyDatabaseEventNotificationAn ALTER ANY DATABASE EVENT NOTIFICATION permission.
AlterAnyDataspaceAn ALTER ANY DATASPACE permission.
AlterAnyFulltextCatalogAn ALTER ANY FULLTEXT CATALOG permission.
AlterAnyMessageTypeAn ALTER ANY MESSAGE TYPE permission.
AlterAnyRemoteServiceBindingAn ALTER ANY REMOTE SERVICE BINDING permission.
AlterAnyRoleAn ALTER ANY ROLE permission.
AlterAnyRouteAn ALTER ANY ROUTE permission.
AlterAnySchemaAn ALTER ANY SCHEMA permission.
AlterAnyServiceAn ALTER ANY SERVICE permission.
AlterAnySymmetricKeyAn ALTER ANY SYMMETRIC KEY permission.
AlterAnyUserAn ALTER ANY USER permission.
AuthenticateAn AUTHENTICATE permission.
BackupDatabaseA BACKUP DATABASE permission.
BackupLogA BACKUP LOG permission.
CheckpointA CHECKPOINT permission.
ConnectA CONNECT permission.
ConnectReplicationA CONNECT REPLICATION permission.
ControlA CONTROL permission.
CreateAggregateA CREATE AGGREGATE permission.
CreateAssemblyA CREATE ASSEMBLY permission.
CreateAsymmetricKeyA CREATE ASYMMETRIC KEY permission.
CreateCertificateA CREATE CERTIFICATE permission.
CreateContractA CREATE CONTRACT permission.
CreateDatabaseA CREATE DATABASE permission.
CreateDatabaseDdlEventNotificationA CREATE DATABASE DDL EVENT NOTIFICATION permission.
CreateDefaultA CREATE DEFAULT permission.
CreateFulltextCatalogA CREATE FULLTEXT CATALOG permission.
CreateFunctionA CREATE FUNCTION permission.
CreateMessageTypeA CREATE MESSAGE TYPE permission.
CreateProcedureA CREATE PROCEDURE permission.
CreateQueueA CREATE QUEUE permission.
CreateRemoteServiceBindingA CREATE REMOTE SERVICE BINDING permission.
CreateRoleA CREATE ROLE permission.
CreateRouteA CREATE ROUTE permission.
CreateRuleA CREATE RULE permission.
CreateSchemaA CREATE SCHEMA permission.
CreateServiceA CREATE SERVICE permission.
CreateSymmetricKeyA CREATE SYMMETRIC KEY permission.
CreateSynonymA CREATE SYNONYM permission.
CreateTableA CREATE TABLE permission.
CreateTypeA CREATE TYPE permission.
CreateViewA CREATE VIEW permission.
CreateXmlSchemaCollectionA CREATE XML SCHEMA COLLECTION permission.
DeleteA DELETE permission.
ExecuteAn EXECUTE permission.
ImpersonateAn IMPERSONATE permission.
InsertAn INSERT permission.
ReceiveA RECEIVE permission.
ReferencesA REFERENCES permission.
SelectA SELECT permission.
SendA SEND permission.
ShowplanA SHOWPLAN permission.
SubscribeQueryNotificationsA SUBSCRIBE QUERY NOTIFICATIONS permission.
TakeOwnershipA TAKE OWNERSHIP permission.
UpdateAn UPDATE permission.
ViewChangeTrackingA VIEW CHANGE TRACKING permission.
ViewDatabaseStateA VIEW DATABASE STATE permission.
ViewDefinitionA VIEW DEFINITION permission.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft