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
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