Roles Element (ASSL)

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

Syntaxe

<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

Notes

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.

Voir aussi

Référence

Collections (ASSL)

Aide et Informations

Assistance sur SQL Server 2005