Security Element (XMLA)

Specifies how to back up or restore security definitions, such as roles and permissions, during a Backup or Restore command.

Syntax

<Backup> <!-- or Restore -->
   ...
   <Security>...</Security>
   ...
</Backup>

Element Characteristics

Characteristic	Description
Data type and length	String (enumeration)
Default value	SkipMembership
Cardinality	0-1: Optional element that can occur once and only once.

Element Relationships

Relationship	Element
Parent elements	Backup, Restore
Child elements	None

Remarks

The Security element determines whether the security definitions, such as roles and permissions, defined on a Microsoft SQL Server Analysis Services database are backed up or restored during, respectively, a Backup or Restore command. This element also determines if the Windows user accounts and groups defined as members of the security definitions are included as part of the Backup or Restore command.

The value of this element is limited to one of the strings listed in the following table.

Value	Description
SkipMembership	Include security definitions, but exclude membership information, during Backup or Restore commands.
CopyAll	Include security definitions and membership information during Backup or Restore commands.
IgnoreSecurity	Exclude security definitions during Backup or Restore commands.

See Also

Reference

SynchronizeSecurity Element (XMLA)

Concepts

Properties (XMLA)

Help and Information

Getting SQL Server 2005 Assistance