Specify which Cubes a Database Role has Access to

Complete the following procedure to specify which cubes a specific role has
access to.
1. In SQL Server Management Studio, connect to your Analysis Services instance.

2. In the tree view, expand the Databases ><OLAP Database Name> > Roles node.

3. Right-click the role for which you want to restrict access. ClickProperties. The Edit Role - <Role Name> form is displayed.

4. In the Select a page pane, click Cubes. A list of the default cubes is
displayed.

5. In the Access column, specify the type of access the selected role
should have for each cube. You can select None, Read, or Read/Write.

6. Click OK.

Regards,
Hossein Karimi