DatabasePermission Class
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.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
| Name | Description | |
|---|---|---|
![]() ![]() | 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. |
![]() ![]() | AlterAnyExternalDataSource | Gets the external data source to alter. |
![]() ![]() | AlterAnyExternalFileFormat | Gets the external file format to alter. |
![]() ![]() | 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. |
![]() ![]() | AlterAnySecurityPolicy | Gets a value that indicates whether to alter any security policy. |
![]() ![]() | 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. |
| Name | Description | |
|---|---|---|
![]() ![]() | Add(DatabasePermission^, DatabasePermission^) | Returns a set of database permissions after adding a new database permission to an existing set of database permissions. |
![]() ![]() | BitwiseOr(DatabasePermission^, DatabasePermission^) | Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects. |
![]() | Equals(Object^) | Determines whether the referenced database permission object is equal to a specified object.(Overrides Object::Equals(Object^).) |
![]() | GetHashCode() | This method supports the SQL Server infrastructure and is not intended to be used directly from your code.(Overrides Object::GetHashCode().) |
![]() | GetType() | (Inherited from Object.) |
![]() ![]() | ToDatabasePermissionSet(DatabasePermission^) | Returns a set of database permissions, based on a single database permission, by converting a DatabasePermission object to a DatabasePermissionSet object. |
![]() | ToString() | (Inherited from Object.) |
| Name | Description | |
|---|---|---|
![]() ![]() | Addition(DatabasePermission^, DatabasePermission^) | Creates a database permission set by performing an addition operation on two DatabasePermission objects. |
![]() ![]() | BitwiseOr(DatabasePermission^, DatabasePermission^) | Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects. |
![]() ![]() | Equality(DatabasePermission^, DatabasePermission^) | Compares two DatabasePermission objects in an equality operation. |
![]() ![]() | Implicit(DatabasePermission^ to DatabasePermissionSet^) | Converts a single database permission object to a database permission set. |
![]() ![]() | Inequality(DatabasePermission^, DatabasePermission^) | Determines whether two T:Microsoft.SqlSrver.Management.Smo.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.
Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.



