SSRS 2008 Snapshotting Security

Posted by Holy Christ on Stack Overflow See other posts from Stack Overflow or by Holy Christ
Published on 2010-04-19T19:20:01Z Indexed on 2010/04/19 19:23 UTC
Read the original article Hit count: 326

Filed under:
|

Hi,

I'm writing a report that will show data based on the User!UserID built into the SSRS infrastructure. The data is sensitive to the user's department.

In addition to these department users, there will be admins that should be able to run for all departments, or have a report parameter to run for a specific department.

Ideally, I'd like to use SSRS snapshotting so that users can rerun a report they ran on a previous date. It's important that a user can only view the snapshots he created for his department.

My questions are: 1.) Does SSRS snapshotting provide a mechanism to limit viewing snapshots by the user that created them? 2.) Will I need to write two reports, one for the admin and one for the department users? I think I do since there isn't a way to secure report parameters.

Thanks!

© Stack Overflow or respective owner

Related posts about ssrs-2008

Related posts about security