DatabasePermission-Klasse

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.

Vererbungshierarchie

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public NotInheritable Class DatabasePermission
'Usage
Dim instance As DatabasePermission

public sealed class DatabasePermission

public ref class DatabasePermission sealed

[<SealedAttribute>]
type DatabasePermission =  class end

public final class DatabasePermission

Der DatabasePermission-Typ macht folgende Elemente verfügbar.

Eigenschaften

	Name	Beschreibung
	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.

Zum Anfang

Methoden

	Name	Beschreibung
	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. (Überschreibt Object. . :: . .Equals(Object).)
	Finalize	(Geerbt von Object.)
	GetHashCode	This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Überschreibt Object. . :: . .GetHashCode() () () ().)
	GetType	(Geerbt von Object.)
	MemberwiseClone	(Geerbt von Object.)
	ToDatabasePermissionSet	Returns a set of database permissions, based on a single database permission, by converting a DatabasePermission object to a DatabasePermissionSet object.
	ToString	(Geerbt von Object.)

Zum Anfang

Operatoren

	Name	Beschreibung
	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 Widening Implicit Implicit 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.

Zum Anfang

Hinweise

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

Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Für Instanzelemente kann nicht sichergestellt werden, dass sie für Threads sicher sind.

Beispiele

Gewährung, Widerrufen und Verweigern von Berechtigungen

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.

Siehe auch

Verweis

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

Berechtigungen (Datenbankmodul)