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 ...