Chapter 12. Implementing Security

In this chapter, you will learn how to:

  • Grant server and database-level administrative rights.

  • Control access to data at the cube, dimension, and cell levels.

Your Analysis Services database has been designed to provide you valuable insight into your business. As such, it represents a sensitive source of information—one that needs to be properly secured.

Properly implemented security ensures administrators have just those permissions they require to perform their duties and end users have access only to the data appropriate to their responsibilities within the business. In this chapter, you will be introduced to the Analysis Services role-based security model and will employ server and database-level roles to configure ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step 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.