Understanding role-based security
The fundamental security object in Analysis Services is a role. A role defines the connection between the security object in Windows, which are groups and users, and the security definitions that you specify in the cube. You can think of the role as a group of users and groups.
By default, there are no defined roles in Analysis Services except for the fixed server role that provides administrative access to the server.
Adding users to the fixed server role
To add users to the fixed server role, you connect the Analysis Services instance using Management Studio.
Right-click on the server in the Object Explorer and choose Properties.
In the Security section, you can find the dialog that will allow you to add more users to the server role:
To secure your cubes, you need to add new database roles. This can either be done in Management Studio or directly in the cube project.
Adding custom roles to the database
Custom security roles can be used to secure the objects...
