A User Is Able to See All Cubes Regardless of Restrictions Put in Place.


The security Role applied to a user in SSAS does not take affective on the user in 
Pyramid I.E the user can see all cubes regardless restrictions put in place.


The cause of this is likely to be, that the user is a local admin on the SSAS server(s) in use.
Removing the user from the local Administrator group and the Security group assigned to them, should resolve the issue.

If after the above changes, the security is still not applied, verify that the “user” is not part of the server administrator role from within the “Microsoft SQL server Management Studio”, if they are they must be removed.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • This was helpful in that it helped me check these settings and make sure they are correct.  Unfortunately, they look correct, yet I still have the issue of a user seeing cubes that they should not be seeing.  Do you have any other tips?

Like Follow
  • 4 yrs agoLast active
  • 1Replies
  • 677Views
  • 2 Following