DatabasePermission Element (ASSL)

 

Applies To: SQL Server 2016 Preview

Defines the default permissions in a Database element for a specific Role element.

  
<DatabasePermissions>  
      <DatabasePermission xsi:type="Permission">  
      <!-- The following elements extend Permission -->  
      <Administer>...</Administer>  
...</DatabasePermission>  
</DatabasePermissions>  

CharacteristicDescription
Data type and lengthPermission
Default valueFalse
Cardinality0-n: Optional element that can occur more than once.
RelationshipElement
Parent elementsDatabasePermissions
Child elementsAdminister

DatabasePermission objects can exist only for roles owned by the database, and only one DatabasePermission object can exist for any role.

This element has the following validations under DeploymentMode value 2 (Tabular Models).

  • Administer attribute default value is set to False, except when the user has administrative privileges. For users with administrative privileges the attribute value is set to True.

The corresponding element in the Analysis Management Objects (AMO) object model is DatabasePermission.

Role Element (ASSL)
Objects (ASSL)

Community Additions

ADD
Show: