O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required