Udostępnij przez

DatabasePermission Members

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.

The following tables list the members exposed by the DatabasePermission type.

Public Properties

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

Top

Public Methods

(see also Protected Methods )

  Name Description
ms219420.pubmethod(pl-pl,SQL.100).gifms219420.static(pl-pl,SQL.100).gif Add Returns a set of database permissions after adding a new database permission to an existing set of database permissions.
ms219420.pubmethod(pl-pl,SQL.100).gifms219420.static(pl-pl,SQL.100).gif BitwiseOr Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.
ms219420.pubmethod(pl-pl,SQL.100).gif Equals Overloaded. Overridden. Determines whether the referenced database permission object is equal to a specified object.
ms219420.pubmethod(pl-pl,SQL.100).gif GetHashCode Overridden. This method supports the SQL Server infrastructure and is not intended to be used directly from your code.
ms219420.pubmethod(pl-pl,SQL.100).gif GetType  (inherited from Object )
ms219420.pubmethod(pl-pl,SQL.100).gifms219420.static(pl-pl,SQL.100).gif op_Addition Creates a database permission set by performing an addition operation on two DatabasePermission objects.
ms219420.pubmethod(pl-pl,SQL.100).gifms219420.static(pl-pl,SQL.100).gif op_BitwiseOr Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.
ms219420.pubmethod(pl-pl,SQL.100).gifms219420.static(pl-pl,SQL.100).gif op_Equality Compares two DatabasePermission objects in an equality operation.
ms219420.pubmethod(pl-pl,SQL.100).gifms219420.static(pl-pl,SQL.100).gif op_Implicit  
ms219420.pubmethod(pl-pl,SQL.100).gifms219420.static(pl-pl,SQL.100).gif op_Inequality Determines whether two DatabasePermission objects are not equal by performing an inequality operation.
ms219420.pubmethod(pl-pl,SQL.100).gifms219420.static(pl-pl,SQL.100).gif ReferenceEquals  (inherited from Object )
ms219420.pubmethod(pl-pl,SQL.100).gifms219420.static(pl-pl,SQL.100).gif ToDatabasePermissionSet Returns a set of database permissions, based on a single database permission, by converting a DatabasePermission object to a DatabasePermissionSet object.
ms219420.pubmethod(pl-pl,SQL.100).gif ToString  (inherited from Object )

Top

Protected Methods

  Name Description
ms219420.protmethod(pl-pl,SQL.100).gif Finalize  (inherited from Object )
ms219420.protmethod(pl-pl,SQL.100).gif MemberwiseClone  (inherited from Object )

Top

  • Last updated on