SSRS 2008: Audit Security Changes to Report Manager Permissions
This is for SSRS 2008 R1 or R2 - and perhaps even 2005...
say you have a reporting environment: myhost/reports
You give a group of people access. You create a folder GroupA and a Folder GroupB
Then you give people content manager access to their own groups A and B.
Say, Person1 edits the security settings on GroupA. Adds or removes a setting, permissions, user, etc.
Is there a way to audit or monitor those changes? Could that be done via API or SQL Triggers? What SSRS table has that info? Could we track that?
October 14th, 2010 10:39pm
Hi,
These changes can't be audited in reporting sevices. Only you can query which users with what permissions against the report server database using the following T-SQL code:
select distinct u.UserName,r.RoleName,r.TaskMask
from Users u inner join PolicyUserRole pur on u.UserID = pur.UserID
inner join Roles r on pur.RoleID = r.RoleID
Hope this helpfully,
thanks,
Jerry
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2010 9:59am