Administrator security concerns users' access to Microsoft® SQL Server™ 2000 Analysis Services data through Analysis Manager and their ability to perform administrative functions. Administrator security is granted through membership in the OLAP Administrators group.
During initial installation, Analysis Services establishes a Microsoft NT® 4.0, Windows® 2000, or Windows XP group named OLAP Administrators. The user account, which must have Machine Administrator rights in order to successfully install Analysis Services, is then added to the OLAP Administrators group. The OLAP Administrators group is a local group on the computer where Analysis Services is installed. Only members of this group can:
- Access the Analysis server through Analysis Manager and perform administrative functions.
- Perform administrative functions on the Analysis server programmatically with Decision Support Objects (DSO).
Administrative functions include maintaining security roles and processing Analysis Services objects.
You can use User Manager in Windows NT 4.0 or Computer Management in Windows 2000 or Windows XP to manage the OLAP Administrators group.
There are not multiple degrees or levels of administrator security. A user either is or is not an administrator, depending on whether he or she is included in the OLAP Administrators group.
When connected to an Analysis server through client applications, members of the OLAP Administrators group have full read access to all cubes and dimensions on the server. They also have full read/write access to all write-enabled cubes and write-enabled dimensions. This access is granted regardless of role definitions on the Analysis server.