Export (0) Print
Expand All
Expand Minimize

MiningModelPermission Element (ASSL)

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


<MiningModelPermissions>
   <MiningModelPermission xsi:type="Permission">
      <!-- The following elements extend Permission -->
      <AllowDrillThrough>...</AllowDrillThrough>
      <AllowBrowsing>...</AllowBrowsing>
   </MiningModelPermission>
</MiningModelPermissions>

Characteristic

Description

Data type and length

Permission

Default value

None

Cardinality

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

Relationship

Element

Parent elements

MiningModelPermissions

Child elements

AllowBrowsing, AllowDrillThrough

In SQL Server 2012, you can enable drillthrough on mining structures by adding the AllowDrillthrough permission to the MiningStructurePermissions collection. If AllowDrillthrough is enabled on both the mining structure and the mining model, any member of a role that has AllowDrillThrough Element (ASSL) permissions on the model can query the data mining model, and return structure columns that were not included in the model, by using the following syntax:

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

Therefore, to protect sensitive data or personal information, you should grant AllowDrillthrough permission on a mining model only when necessary. For more information, see AllowDrillThrough Element (ASSL).

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

Community Additions

ADD
Show:
© 2014 Microsoft