Report Model security
I have been playing with SRS 2005 for a few months now and have a decent setup going but am strugling with model security.
I have set my selected users up in the home folder and also as site users in site settings, they can launch the report builder and create reports fine.
HOWEVER
I intend to use the software accross multiple systems ie WMS, TMS, Finance package, T&A and therefore I only want the WMS users to see the WMS models and T&A users to only see the T&A models etc
No matter what settings are adjusted it seems that if you can launch the report builder then you can access all models and this poses an issue for me as systems like T&A and financials that I need to be as secure as possible.
I am aware that I can limit access toto modelsusing Management studio but it seems to be basically on a column basis rather than the whole model.
Help!!!
Also aware of the fact im an idiot and basically posted the same thing 5 or 6 times! Hopefully the others are deleted
February 6th, 2008 9:11pm
Mike,
You can fine tune the security of Report models by connect to the Reporting Services via Managment Studio.
One of the option is "Report Builder". You can selectively give that to the users you would like to have.
Rahul
Free Windows Admin Tool Kit Click here and download it now
February 6th, 2008 10:43pm
Hi Mike,
How you were able to solve this problem?
Please post the solution coz I have the same problem.
Thanks!
Cpatil
January 18th, 2011 4:44pm


