Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Roles Element (ASSL)

 

Applies To: SQL Server 2016 Preview

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


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

Characteristic

Description

Data type and length

None

Default value

None

Cardinality

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

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.

Community Additions

ADD
Show:
© 2015 Microsoft