Administrator Security
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.
By default, the user account used to install the Analysis server on a particular computer is granted administrative permissions on that computer. Upon initial installation, Analysis Services establishes a Microsoft Windows NT® 4.0 or Windows® 2000 group named OLAP Administrators and adds the logged-on user to this 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 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.