Creating Security Roles

Analysis Services security is based on and integrated with the security in Microsoft Windows NT (either Windows NT version 4 or Microsoft Windows 2000). When you define security in Analysis Services, you create roles in the OLAP database. Each role can contain one or more specific user accounts or user groups as defined in the operating system. Once you’ve created a database role, you can associate that role with cubes or virtual cubes in the OLAP database. In addition, you can fine-tune security within a cube by restricting access to metadata (the members on dimensions) as well as access to data (the values stored in the cubes).

Note

Analysis Services automatically creates an OLAP Administrators group in the operating ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step 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.