MiningModelPermission Element (ASSL)

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

Syntax


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

Element Characteristics

Characteristic Description
Data type and length Permission
Default value None
Cardinality 0-n: Optional element that can occur more than once.

Element Relationships

Relationship Element
Parent elements MiningModelPermissions
Child elements AllowBrowsing, AllowDrillThrough

Remarks

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.

See Also

Objects (ASSL)