Chapter 7. Analysis Services Security
In this chapter, we will cover:
- Managing instance-level administrative security
- Managing database-level security
- Managing cube-level security
- Managing dimension hierarchy-level security
- Implementing dynamic security
- Implementing cell-level security
Introduction
This chapter teaches how to secure Analysis Services starting at the instance level and working all the way down to the individual cube cells. Analysis Services administrators have unrestricted access to all items within the server—they can restart the service, read and process data in every database, dimension, and cube, alter configuration settings, collect traces, and so on. This level of access is best reserved for database administrators. SSAS developers ...
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.
