How are cubes secured?
A. Analysis Services has a robust security model that allows setting permissions for groups on dimensions all the way down to the cell level. In addition, you can limit the administrators that are permitted to access Analysis Services data through Analysis Manager and perform administrative functions. You can also restrict end users who access data on the Analysis server through client applications as well as specify which end users can access data and the types of operations they can perform. Administrator security is controlled using the Microsoft Windows NT® 4.0 or Microsoft Windows® 2000 group named OLAP Administrators. End-user security is controlled by a combination of: • Authentication during connection to the Analysis server. • Database, cube, and mining model roles defined in Analysis Manager. Each role defines a set of users and the access they all share. A role is defined at the Analysis Services database level and then assigned to cubes that the users in the role are permit
