Roles Element (ASSL)

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

Синтаксис

<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

Замечания

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.

См. также

Справочник

Collections (ASSL)

Справка и поддержка

Получение помощи по SQL Server 2005