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
October 18th, 2010 9:59am