http://www.sqlservercentral.com/blogs/dknight/2010/12/28/ssas-understanding-multiple-security-roles/

Printed 2014/09/19 09:57PM

SSAS Understanding Multiple Security Roles

2010/12/28

In a previous article I showed how you can create dynamic security in SSAS.  This is a great way to make all security table based using Active Directory accounts associated with the items that the user is allowed to see. 

If you decide that your security model is pretty basic and it is not necessary to implement the table based security then you should be aware of a side effect of having multiple Analysis Services roles.  The side effect I’m referring is having a user that falls under multiple roles.  This is probably a very common occurrence when using Active Directory groups in your roles.  Let’s say for example you Bill is part of an AD group that is meant for the southeast sales department, but he also is a part of an AD group that is meant for the northwest sales department.  If these two groups are used in two different roles then Bill is able to see everything available in both roles.  When a user is part of two roles SSAS takes a UNION of those two roles.  The image below demonstrates this.  The area in green representing what Bill can see.

 

I hope this helps if you are trying to figure out why your security model is not working.  You know now to check and make sure a user is not part of multiple roles.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.