• Article

DatabasePermission Members

Include Protected Members
Include Inherited 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 DatabasePermission type exposes the following members.

Methods

  Name Description
Public methodStatic member Add(DatabasePermission, DatabasePermission) Returns a set of database permissions after adding a new database permission to an existing set of database permissions.
Public methodStatic member BitwiseOr(DatabasePermission, DatabasePermission) Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.
Public method Equals(Object) Determines whether the referenced database permission object is equal to a specified object. (Overrides Object.Equals(Object).)
Protected method Finalize() (Inherited from Object.)
Public method GetHashCode() This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Overrides Object.GetHashCode().)
Public method GetType() (Inherited from Object.)
Protected method MemberwiseClone() (Inherited from Object.)
Public methodStatic member ToDatabasePermissionSet(DatabasePermission) Returns a set of database permissions, based on a single database permission, by converting a DatabasePermission object to a DatabasePermissionSet object.
Public method ToString() (Inherited from Object.)

Top

Operators

  Name Description
Public operatorStatic member Addition(DatabasePermission, DatabasePermission) Creates a database permission set by performing an addition operation on two DatabasePermission objects.
Public operatorStatic member BitwiseOr(DatabasePermission, DatabasePermission) Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.
Public operatorStatic member Equality(DatabasePermission, DatabasePermission) Compares two DatabasePermission objects in an equality operation.
Public operatorStatic member Implicit(DatabasePermission to DatabasePermissionSet)
Public operatorStatic member Inequality(DatabasePermission, DatabasePermission) Determines whether two DatabasePermission objects are not equal by performing an inequality operation.

Top

Properties

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

Top