Administer Element (ASSL)

Indicates whether the associated permission includes the right to administer a Database element.

Syntax

<DatabasePermission>
      ...
      <Administer>...</Administer>
   ...
</DatabasePermission>

Element Characteristics

Characteristic Description

Data type and length

Boolean

Default value

False

Cardinality

0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent elements

DatabasePermission

Child elements

None

Remarks

The Administer element indicates whether a user can perform administrative functions only on the specified database. The server administrator role can perform administrative functions on all databases contained by the instance.

The element that corresponds to the parent of Administer in the Analysis Management Objects (AMO) object model is DatabasePermission.

See Also

Reference

Permission Data Type (ASSL)
Role Element (ASSL)
Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance