This topic has not yet been rated - Rate this topic

DatabasePermission Properties

SQL Server 2012

The DatabasePermission type exposes the following members.

	Name	Description
	Alter	Gets a permission that can be included in the database permission set.
	AlterAnyApplicationRole	Gets a permission that can be included in the database permission set.
	AlterAnyAssembly	Gets a permission that can be included in the database permission set.
	AlterAnyAsymmetricKey	Gets a permission that can be included in the database permission set.
	AlterAnyCertificate	Gets a permission that can be included in the database permission set.
	AlterAnyContract	Gets a permission that can be included in the database permission set.
	AlterAnyDatabaseAudit	Gets a permission that can be included in the database permission set.
	AlterAnyDatabaseDdlTrigger	Gets a permission that can be included in the database permission set.
	AlterAnyDatabaseEventNotification	Gets a permission that can be included in the database permission set.
	AlterAnyDataspace	Gets a permission that can be included in the database permission set.
	AlterAnyFulltextCatalog	Gets a permission that can be included in the database permission set.
	AlterAnyMessageType	Gets a permission that can be included in the database permission set.
	AlterAnyRemoteServiceBinding	Gets a permission that can be included in the database permission set.
	AlterAnyRole	Gets a permission that can be included in the database permission set.
	AlterAnyRoute	Gets a permission that can be included in the database permission set.
	AlterAnySchema	Gets a permission that can be included in the database permission set.
	AlterAnyService	Gets a permission that can be included in the database permission set.
	AlterAnySymmetricKey	Gets a permission that can be included in the database permission set.
	AlterAnyUser	Gets a permission that can be included in the database permission set.
	Authenticate	Gets a permission that can be included in the database permission set.
	BackupDatabase	Gets a permission that can be included in the database permission set.
	BackupLog	Gets a permission that can be included in the database permission set.
	Checkpoint	Gets a permission that can be included in the database permission set.
	Connect	Gets a permission that can be included in the database permission set.
	ConnectReplication	Gets a permission that can be included in the database permission set.
	Control	Gets a permission that can be included in the database permission set.
	CreateAggregate	Gets a permission that can be included in the database permission set.
	CreateAssembly	Gets a permission that can be included in the database permission set.
	CreateAsymmetricKey	Gets a permission that can be included in the database permission set.
	CreateCertificate	Gets a permission that can be included in the database permission set.
	CreateContract	Gets a permission that can be included in the database permission set.
	CreateDatabase	Gets a permission that can be included in the database permission set.
	CreateDatabaseDdlEventNotification	Gets a permission that can be included in the database permission set.
	CreateDefault	Gets a permission that can be included in the database permission set.
	CreateFulltextCatalog	Gets a permission that can be included in the database permission set.
	CreateFunction	Gets a permission that can be included in the database permission set.
	CreateMessageType	Gets a permission that can be included in the database permission set.
	CreateProcedure	Gets a permission that can be included in the database permission set.
	CreateQueue	Gets a permission that can be included in the database permission set.
	CreateRemoteServiceBinding	Gets a permission that can be included in the database permission set.
	CreateRole	Gets a permission that can be included in the database permission set.
	CreateRoute	Gets a permission that can be included in the database permission set.
	CreateRule	Gets a permission that can be included in the database permission set.
	CreateSchema	Gets a permission that can be included in the database permission set.
	CreateService	Gets a permission that can be included in the database permission set.
	CreateSymmetricKey	Gets a permission that can be included in the database permission set.
	CreateSynonym	Gets a permission that can be included in the database permission set.
	CreateTable	Gets a permission that can be included in the database permission set.
	CreateType	Gets a permission that can be included in the database permission set.
	CreateView	Gets a permission that can be included in the database permission set.
	CreateXmlSchemaCollection	Gets a permission that can be included in the database permission set.
	Delete	Gets a permission that can be included in the database permission set.
	Execute	Gets a permission that can be included in the database permission set.
	Insert	Gets a permission that can be included in the database permission set.
	References	Gets a permission that can be included in the database permission set.
	Select	Gets a permission that can be included in the database permission set.
	Showplan	Gets a permission that can be included in the database permission set.
	SubscribeQueryNotifications	Gets a permission that can be included in the database permission set.
	TakeOwnership	Gets a permission that can be included in the database permission set.
	Update	Gets a permission that can be included in the database permission set.
	ViewDatabaseState	Gets a permission that can be included in the database permission set.
	ViewDefinition	Gets a permission that can be included in the database permission set.

Top

Reference

DatabasePermission Class

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD