Share via

DatabasePermission Members

  • Article

The DatabasePermission object represents a Microsoft 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(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif Alter Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyApplicationRole Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyAssembly Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyAsymmetricKey Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyCertificate Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyContract Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyDatabaseDdlTrigger Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyDatabaseEventNotification Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyDataspace Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyFulltextCatalog Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyMessageType Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyRemoteServiceBinding Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyRole Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyRoute Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnySchema Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyService Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnySymmetricKey  
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif AlterAnyUser Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif Authenticate Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif BackupDatabase Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif BackupLog Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif Checkpoint Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif Connect Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif ConnectReplication Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif Control Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateAggregate Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateAssembly Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateAsymmetricKey Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateCertificate Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateContract Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateDatabase Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateDatabaseDdlEventNotification Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateDefault Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateFulltextCatalog Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateFunction Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateMessageType Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateProcedure Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateQueue Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateRemoteServiceBinding Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateRole Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateRoute Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateRule Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateSchema Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateService Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateSymmetricKey Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateSynonym Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateTable Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateType Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateView Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif CreateXmlSchemaCollection Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif Delete Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif Execute Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif Insert Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif References Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif Select Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif Showplan Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif SubscribeQueryNotifications Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif TakeOwnership Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif Update Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif ViewDatabaseState Gets a permission that can be included in the database permission set.
ms219420.pubproperty(en-US,SQL.90).gifms219420.static(en-US,SQL.90).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(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif Add Returns a set of database permissions after adding a new database permission to an existing set of database permissions.
ms219420.pubmethod(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif BitwiseOr  
ms219420.pubmethod(en-US,SQL.90).gif Equals Overloaded. Overridden.  
ms219420.pubmethod(en-US,SQL.90).gif GetHashCode Overridden. This method supports the SQL Server 2005 infrastructure and is not intended to be used directly from your code.
ms219420.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219420.pubmethod(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif op_Addition Creates a database permission set by performing an addition operation on two DatabasePermission objects.
ms219420.pubmethod(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif op_BitwiseOr Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.
ms219420.pubmethod(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif op_Equality Compares two DatabasePermission objects in an equality operation.
ms219420.pubmethod(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif op_Implicit  
ms219420.pubmethod(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif op_Inequality  
ms219420.pubmethod(en-US,SQL.90).gifms219420.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219420.pubmethod(en-US,SQL.90).gifms219420.static(en-US,SQL.90).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(en-US,SQL.90).gif ToString  (inherited from Object )

Top

Protected Methods

  Name Description
ms219420.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms219420.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

DatabasePermission Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Granting, Revoking, and Denying Permissions
Permissions