Share via

DatabasePermission Element (ASSL)

  • Article

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

Syntax

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

Element Characteristics

Characteristic Description

Data type and length

Permission

Default value

None

Cardinality

0-n: Optional element that can occur more than once.

Element Relationships

Relationship Element

Parent elements

DatabasePermissions

Child elements

Administer

Remarks

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

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

See Also

Reference

Role Element (ASSL)
Objects (ASSL)

Help and Information

Getting SQL Server 2005 Assistance