MiningModelPermission Element (ASSL)
<MiningModelPermissions> <MiningModelPermission xsi:type="Permission"> <!-- The following elements extend Permission --> <AllowDrillThrough>...</AllowDrillThrough> <AllowBrowsing>...</AllowBrowsing> </MiningModelPermission> </MiningModelPermissions>
|Data type and length||Permission|
|Cardinality||0-n: Optional element that can occur more than once.|
|Child elements||AllowBrowsing, AllowDrillThrough|
In SQL Server 2017, 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.