Security Element
TOC
Collapse the table of content
Expand the table of content

Security Element (XMLA)

 

Applies To: SQL Server 2016 Preview

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>  

CharacteristicDescription
Data type and lengthString (enumeration)
Default valueSkipMembership
Cardinality0-1: Optional element that can occur once and only once.
RelationshipElement
Parent elementsBackup, Restore
Child elementsNone

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.

ValueDescription
SkipMembershipInclude security definitions, but exclude membership information, during Backup or Restore commands.
CopyAllInclude security definitions and membership information during Backup or Restore commands.
IgnoreSecurityExclude security definitions during Backup or Restore commands.

SynchronizeSecurity Element (XMLA)
Properties (XMLA)

Community Additions

ADD
Show:
© 2016 Microsoft