SSRS 2008 Snapshotting Security
- by Holy Christ
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!