Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I'm reasonably new to SQL Server Reporting Services and Report Manager, and completely new to SSRS's Subscriptions. We're running SSRS 2008.

Out of the box it seems that a user with the Browser role can create a Subscription to a report and schedule it to run at any time they choose.

As an admin I have setup a schedule called "Overnight reports" and have it run every night from 1am.

I would like it so that when a regular user creates their Subscription they can only use one of my shared schedules so that their subscription will only run overnight.

Is this possible?

Thanks

-Matt

share|improve this question

2 Answers 2

No SSRS does not support this level of granularity with its security model.

I entered this connect feature request awhile back, please upvote it if you think it would be useful:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=458776

share|improve this answer

You can create the report so it generates from a snapshot - under execution options "Render this report from a report execution snapshot"

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.