SynchronizeSecurity Element (XMLA)


Applies To: SQL Server 2016 Preview

Specifies how to synchronize security definitions, such as roles and permissions, during a Synchronize command.


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

The Security element determines whether the security definitions, such as roles and permissions, defined on an Microsoft SQL Server Analysis Services database are synchronized during a Synchronize 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 Synchronize command.

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

SkipMembershipInclude security definitions, but exclude membership information, during a Synchronize command.
CopyAllInclude security definitions and membership information during a Synchronize command.
IgnoreSecurityExclude security definitions during a Synchronize command.

Security Element (XMLA)
Properties (XMLA)

Community Additions