共用方式為


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 協助