Hi,
I need guidance in beefing up the security in an SSAS 2005 cube that I manage. The cube was created with a single "everyone.role" which allows read access to the built-in role "everyone", all other tabs in the role are mostly blank or default leaving the cube very exposed. I have been tasked to limit the access in the cube to 2 distinct Active Directory groups. Lets call them Grp1 and Grp2. If a user is not in Grp1 or Grp2 then they have no access to the cube.
The primary access rules being:
- Data source is simple star schema, and for most dimensions and all their measures, both Grp1 and Grp2 are allowed to access and read the contents.
- For other dimensions (and all measures within this dimension), Grp1 is allowed full access but Grp2 must be denied access to the entire dimension (dimension level).
- For another dimension, Grp1 can access all, but Grp2 must only access some of the measures within this dimension (measure level).
- Lastly, Grp1 can access all calculated measures but Grp2 is only allowed to access some of the calculated measures.
Can anyone point me in the right direction, I am looking for a how-to or tut which can answer most if not all of my requirements listed above.
Thanks in advance, Chas.