O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

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

Roles

Perspectives and translations allow specific groups of users to see customized views of your cubes, but only real security settings can prevent users from seeing specific items in your physical cubes. By defining one or more roles in your Analysis Services project, you can restrict the access that specific users or groups have to certain data sources, cubes, dimensions, attributes, members, and even individual cube cells in your Analysis Services database.

You can block access to objects completely or limit users’ permissions to read-only access; you can also control whether users in the role can process the entire database, specific cubes, and/or specific dimensions. Last, you can assign administrator rights within the database to certain ...

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