Wednesday, March 28, 2012

Row-Level Security?

I was wondering if anyone had links, best practices, anything... on using RLS (Row-Level Security) with SSAS.

I currently use logged in user to do RLS in relational reporting.

Thanks.

Hi Billg,

There really isn't such a thing as RLS in Analysis Services, its Dimension Security, where you limit what Dimension Members a user can see, or Cell Level Security where you limit the individual Cells someone can see. There are several books for SSAS 2005 that describ the security really well. Also search on Dynamic Security and you will get hits on how to setup security in SSAS. Here is a webcast from my friends in support, its old but still applies to 2005.

http://support.microsoft.com/kb/828343

Hope this helps,

David

No comments:

Post a Comment