Класс DatabasePermission

The DatabasePermission object represents a SQL Server database permission. The database permission can be added to a database permission set, and then granted, revoked, or denied to a user.

Иерархия наследования

System.Object
  Microsoft.SqlServer.Management.Smo.DatabasePermission

Пространство имен:  Microsoft.SqlServer.Management.Smo
Сборка:  Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
Public NotInheritable Class DatabasePermission
'Применение
Dim instance As DatabasePermission

public sealed class DatabasePermission

public ref class DatabasePermission sealed

[<SealedAttribute>]
type DatabasePermission =  class end

public final class DatabasePermission

Тип DatabasePermission обеспечивает доступ к следующим элементам.

Свойства

	Имя	Описание
	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.

В начало

Методы

	Имя	Описание
	Add	Returns a set of database permissions after adding a new database permission to an existing set of database permissions.
	BitwiseOr	Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.
	Equals	Determines whether the referenced database permission object is equal to a specified object. (Переопределяет Object.Equals(Object).)
	GetHashCode	This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Переопределяет Object.GetHashCode().)
	GetType	(Производный от Object.)
	ToDatabasePermissionSet	Returns a set of database permissions, based on a single database permission, by converting a DatabasePermission object to a DatabasePermissionSet object.
	ToString	(Производный от Object.)

В начало

Операторы

	Имя	Описание
	Addition	Creates a database permission set by performing an addition operation on two DatabasePermission objects.
	BitwiseOr	Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.
	Equality	Compares two DatabasePermission objects in an equality operation.
	Implicit(DatabasePermission to DatabasePermissionSet)	Converts a single database permission object to a database permission set.
	Inequality	Determines whether two DatabasePermission objects are not equal by performing an inequality operation.

В начало

Замечания

Database permissions are required when running granting, denying, or revoking permissions on a database. The DatabasePermission object is used to specify the set of permissions that apply to the Grant, Deny, and Revoke methods of the Database object. Also, database permissions can be added to the DatabasePermissionSet object, which can also be used with the Grant, Deny, and Revoke methods.

Thread Safety

Все общие статические члены этого типа (Shared в Microsoft Visual Basic) можно использовать в многопоточных операциях. Потокобезопасная работа с членами экземпляров типа не гарантируется.

Примеры

Предоставление, отмена и запрет разрешений

Безопасность многопоточности

Любые открытые статический (Shared в Visual Basic) элементы этого типа потокобезопасны. Потокобезопасность с элементами экземпляров не гарантируется.

См. также

Справочник

Пространство имен Microsoft.SqlServer.Management.Smo

Другие ресурсы

Разрешения (компонент Database Engine)