Managing cube-level security
You already learned how to define SSAS instance administrators and how to grant the necessary permission to cube developers. Now, it's time to secure the solution at the cube level so that each user is permitted to see only the data that they require to perform their job functions.
Each database could have multiple cubes. Cube-level data is also secured using roles, and (not surprisingly) cube-level security is defined on the Cubes tab.
How to do it...
Let's get started by performing the following steps:
- Open the role that you created in the previous recipe, navigate to the Cubes tab, and note the Access, Local Cube/Drillthrough Access and Process settings.
- Cube users could have three levels of access:
None: They cannot ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
