DatabasePermission Element (ASSL)

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