Security Enhancements
This release of Microsoft® SQL Server™ 2000 Analysis Services includes features that provide more flexibility in controlling access to cube data, additional methods for authentication of users, and enhanced enforcement of roles.
Dimension Security
You can use roles to control end-user access to dimensions. For each role, you can limit access to individual dimensions, levels, and members, and you can set various read and read/write permissions. For more information, see Dimension Security.
Enhanced Cell Security
Analysis Manager now includes dialog boxes that enable you to define cell security by setting role options to control end user access to cube cells. You can limit a role's access to any combination of a cube's cells and you can vary the read and read/write permission of the role. For more information, see Cell Security.
Additional Authentication Methods
You can use HTTP authentication methods for client connections to Analysis servers. Analysis Services also supports Windows 2000® negotiated protocol authentication. For more information, see Server Security and Authentication.
Enhanced Role Enforcement
Role specifications are enforced on Analysis servers installed on either file allocation table (FAT) or NTFS file systems.