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
Collapse the table of content
Expand the table of content
Expand Minimize

MiningStructurePermission Element (ASSL)


Applies To: SQL Server 2016 Preview

Defines the permissions that members of a Role element have on an individual MiningStructure element.

   <MiningStructurePermission xsi:type="Permission">

      <!-- This element also inherits all the child elements listed in Permission -->



Data type and length


Default value



0-n: Optional element that can occur more than once.



Parent elements


Child elements


The corresponding element in the Analysis Management Objects (AMO) object model is MiningStructurePermission.

In SQL Server 2016, the permission AllowDrillthrough has been extended to apply to a mining structure. When you assign this permission to a role, any user who is a member of that role can directly query the mining structure by using the following syntax:

SELECT <structure column list> FROM <structure>.CASES

Moreover, if AllowDrillthrough is enabled on both the mining structure and the mining model, users can query structure columns that were not included in the mining model by using the following syntax:

SELECT StructureColumn('<structure column name>' FROM <model>.CASES

For example, you create a model using only columns for customer key, customer income, and customer purchases. By using drillthrough, a user can return other structure columns that were not included in the mining model, such as customer contact information.

Therefore, to protect sensitive data or personal information, you should construct your data source view to mask personal information and grant AllowDrillthrough permission on a structure only when necessary.

For more information, see Drillthrough Queries (Data Mining).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft