Export (0) Print
Expand All

Granting Access to Mining Structures and Mining Models

By default, a database role in Microsoft SQL Server 2005 Analysis Services (SSAS) has no permissions to view any mining structures or mining models in the database. However, an Analysis Services database role can be granted access permissions to a mining model or mining structure.

A database role can have either read or read/write permissions to one or more mining structures in the database. If the database role has read or read/write permissions on a mining structure, those permissions apply to all mining models that are based on that structure, unless different permissions have been specified for one or more mining models.

To grant read or read/write permissions to a database role, a user must be a member of the Analysis Services server role or a member of an Analysis Services database role that has Full Control (Administrator) permissions.

  1. In SQL Server Management Studio, connect to the instance of Analysis Services, expand Roles for the appropriate database in Object Explorer, and then click a database role (or create a new database role).

  2. Click Mining Structure in the Select a Page pane, locate the mining structure in the Mining Structures list, and then select Read or Read/Write in the Access list for the mining structure.

A database role can have read or read/write permissions, as well as drillthrough and browse permissions, on one or more mining models in the database. Drillthrough and browse permissions allow the database role to view and browse the underlying data in the relational database.

To grant read or read/write permissions to a database role, a user must be a member of the Analysis Services server role or a member of an Analysis Services database role that has Full Control (Administrator) permissions.

  1. In SQL Server Management Studio, connect to the instance of Analysis Services, expand Roles for the appropriate database in Object Explorer, and then click a database role (or create a new database role).

  2. Click Mining Structure in the Select a Page pane, locate the mining model in the Mining Models list, and then select Read, Read/Write, Drill Through, or Browse for that mining model.

To use a data source in a drillthrough query that uses the Data Mining Extensions (DMX) OPENQUERY clause, the database role also needs read/write permission on the appropriate data source object. For more information, see Granting Access to Data Sources and OPENQUERY (DMX).

ms175384.note(en-US,SQL.90).gifNote:
By default, the submission of DMX queries by using an ad-hoc connection string in the OPENROWSET clause is disabled. For more information, see Securing the Data Sources Used by Analysis Services.

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

Community Additions

ADD
Show:
© 2014 Microsoft