Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Chapter Summary

To	Do this
Allow all network users to see the contents of a cube	Right-click the cube, and click Manage Roles. Click New, type a name for the role, and click Add. Select the Every one group, click Add, and then click OK twice.
Duplicate an existing role	Right-click the Database Roles folder, and click Manage Roles. Select a role and click Duplicate. Type a name for the new role, and click OK.
Change which cubes are assigned to a role	Select a role, and click the ellipsis button in the Cubes & Mining Models column. To the left of each cube name, select the check box to apply the role to that cube or clear the check box to remove the role from the cube.
To restrict access to a dimension of a cube	Right-click the cube, and click Manage Roles. ...