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

Security Element (XMLA)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

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

Characteristic

Description

Data type and length

String (enumeration)

Default value

SkipMembership

Cardinality

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

Relationship

Element

Parent elements

Backup, Restore

Child elements

None

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.

Community Additions

ADD
Show:
© 2015 Microsoft