February 14, 2009 at 4:36 am
I am trying to set up a report builder installation for a customer and am struggling with implementing the security for it.
I have a number of different models defined using a common datasource e.g. "Sales", "Admin", "Finance". The requirement is that different users of the system have access to different combinations of models. User security is managed through Active Directory, and SQL Server is using Windows Authentication.
I have played around with the roles in Report Manager but cannot seem to limit what a user sees in the Report Builder - apparently they can always access all available models once they access to the report builder.
Is there any way to limit which models a user sees when they open Report Builder? It seems such an obvious requirement, that I cannot believe there isn't.
----
Regards
Andy Kramek
February 16, 2009 at 8:08 am
Please don't cross post. Post answers here, http://www.sqlservercentral.com/Forums/Topic657164-359-1.aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 16, 2009 at 9:01 am
Sorry, but I missed seeing the Security section first time around and posted here in error.
----
Regards
Andy Kramek
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply