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


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

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.