Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Applying Security to a Dimension

When you apply security at the cube level, you simply allow or disallow access to the entire cube. That is often appropriate, but it gives you no flexibility. Often you want managers to see information unavailable to individual contributors, or you don’t want individuals in the marketing department to see budget details from the manufacturing department. Dimension-level security provides a powerful, but simple, mechanism for granting partial access to a cube.

Fully Restrict a Dimension

The simplest—and most useful—option for restricting access to a dimension is to prevent all access other than to the top-level member. Earlier in this lesson, you gave complete access to the Sales cube to all users. Perhaps you ...