Export (0) Print
Expand All

DatabasePermission Class

 

Applies To: SQL Server 2016 Preview

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.

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

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

public ref class DatabasePermission sealed 

NameDescription
System_CAPS_pubpropertySystem_CAPS_staticAlter

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyApplicationRole

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyAssembly

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyAsymmetricKey

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyCertificate

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyContract

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyDatabaseAudit

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyDatabaseDdlTrigger

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyDatabaseEventNotification

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyDataspace

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyFulltextCatalog

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyMessageType

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyRemoteServiceBinding

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyRole

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyRoute

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnySchema

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyService

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnySymmetricKey

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAlterAnyUser

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticAuthenticate

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticBackupDatabase

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticBackupLog

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCheckpoint

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticConnect

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticConnectReplication

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticControl

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateAggregate

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateAssembly

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateAsymmetricKey

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateCertificate

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateContract

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateDatabase

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateDatabaseDdlEventNotification

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateDefault

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateFulltextCatalog

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateFunction

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateMessageType

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateProcedure

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateQueue

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateRemoteServiceBinding

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateRole

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateRoute

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateRule

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateSchema

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateService

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateSymmetricKey

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateSynonym

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateTable

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateType

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateView

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticCreateXmlSchemaCollection

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticDelete

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticExecute

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticInsert

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticReferences

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticSelect

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticShowplan

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticSubscribeQueryNotifications

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticTakeOwnership

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticUpdate

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticViewDatabaseState

Gets a permission that can be included in the database permission set.

System_CAPS_pubpropertySystem_CAPS_staticViewDefinition

Gets a permission that can be included in the database permission set.

NameDescription
System_CAPS_pubmethodSystem_CAPS_staticAdd(DatabasePermission^, DatabasePermission^)

Returns a set of database permissions after adding a new database permission to an existing set of database permissions.

System_CAPS_pubmethodSystem_CAPS_staticBitwiseOr(DatabasePermission^, DatabasePermission^)

Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.

System_CAPS_pubmethodEquals(Object^)

Determines whether the referenced database permission object is equal to a specified object.(Overrides Object::Equals(Object^).)

System_CAPS_pubmethodGetHashCode()

This method supports the SQL Server infrastructure and is not intended to be used directly from your code.(Overrides Object::GetHashCode().)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodSystem_CAPS_staticToDatabasePermissionSet(DatabasePermission^)

Returns a set of database permissions, based on a single database permission, by converting a DatabasePermission object to a DatabasePermissionSet object.

System_CAPS_pubmethodToString()

(Inherited from Object.)

NameDescription
System_CAPS_puboperatorSystem_CAPS_staticAddition(DatabasePermission^, DatabasePermission^)

Creates a database permission set by performing an addition operation on two DatabasePermission objects.

System_CAPS_puboperatorSystem_CAPS_staticBitwiseOr(DatabasePermission^, DatabasePermission^)

Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.

System_CAPS_puboperatorSystem_CAPS_staticEquality(DatabasePermission^, DatabasePermission^)

Compares two DatabasePermission objects in an equality operation.

System_CAPS_puboperatorSystem_CAPS_staticImplicit(DatabasePermission^ to DatabasePermissionSet^)

Converts a single database permission object to a database permission set.

System_CAPS_puboperatorSystem_CAPS_staticInequality(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.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft