Skip to content

security-element-xmla.md

Latest commit

 

History

History
76 lines (63 loc) · 3.12 KB

security-element-xmla.md

File metadata and controls

76 lines (63 loc) · 3.12 KB
title Security Element (XMLA) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
Security Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
microsoft.xml.analysis.security
urn:schemas-microsoft-com:xml-analysis#Security
helpviewer_keywords
Security element
ms.assetid 0b601f69-d16d-4d10-9361-b8afaa6ed357
caps.latest.revision 12
author jeannt
ms.author jeannt
manager erikre

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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] 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

SynchronizeSecurity Element (XMLA)
Properties (XMLA)