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

Get Programming Microsoft® SQL Server™ 2008 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.