Partilhar via

Roles Element (ASSL)

  • Artigo

Contains the collection of Role elements defined under the parent element.

Syntax

<Database> <!-- or Server -->
   ...
   <Roles>
      <Role>...</Role>
   </Roles>
   ...
</Database>

Element Characteristics

Characteristic Description

Data type and length

None

Default value

None

Cardinality

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

Element Relationships

Relationship Element

Parent elements

Database, Server

Child elements

Role

Remarks

The Roles element associated with a Server element contains only one role, named Administrators, which represents the server administrator role. The server administrator role cannot be changed or deleted, nor can additional roles be added to the collection.

The Roles element associate with a Database element contains the roles defined for that database.

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

See Also

Reference

Collections (ASSL)

Help and Information

Getting SQL Server 2005 Assistance