Limit Report Server Access

All,

I'm looking at the possibility of allowing only certian tasks and reports to be available to users. I want the user to only have so much control...but would like them to be able to run reports, subscribe to reports and be able to use the query builder. We don't want the user to see all of the reports in the organization, just the reports for there specific department. So I don't know that I want them to see the report server itself...but maybe be able to run certian features.

Can this be done?Sure, look up the security section of the Reporting Services books online. This describes RS 2000 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_security_v1_3hia.asp
There are some changes for Yukon, but only minor, they have to do with the introduction of Report builder.

Thanks
Tudor|||Tudor,

Thanks. I didn't mention that I am using RS 2005. But I don't know if this article adresses what I am looking for. If I can use the existing RS interface that is great. But I didn't want to show items that are not available. So for example, I will have a person log into a sales region and when they go to run reprots they will only see Sales reports. I don't want them to see executive reports in the list. I know I can limit the permissions on the reprot so they get an error, but I'm really trying to make it so they don't see what they can't run.

If not then I need to try and limit what they can do in my code. But them my question is how I can access report builder and subscription via code.

Thanks for the assistance!|||Is there a way to limit reports listed in the Report Viewer based on groups?
For example, Sales can only see Sales reports in the Report Manager. They can't see reports for other divisions, like IT, Directors, HR.|||If a certain user doesn't have READ permissions on a folder, report, datasource, they won't see it returned from the Report server SOAP APIs, not see it in report manager, SQL Management Studio, etc...

The permissions have changed slightly in RS 2005, but there are only additions to support the new features: report builder, models.

Thanks
Tudor|||Tudor,

Thanks for the answer. However, I'm not seeing the expected results.
I have 5 reports. I took away permissions on 1 report and the item still shows in the Report Manager. When I click on it, it only shows me a few properties instead of showing me the report. How can I prevent the report without adequete security from being displayed?

Thanks!|||

Local administrators on the report server machine will get read properties and read/set security on all items.
If you try to access using an account that's not in the local administrators group, you should get no access at all.

Thanks
Tudor