Report Permissions 2

[ptheriault]

Is there anyway to report on the permissions each group has within reporting services? I would like to have a weekly report that would show what folders, models, and reports each domain group has access to from within report manager. I need an easy view that will show me all the permissions without having to open each folder\report\model and selecting security.

Thanks

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[fuzzyocelot]

I'm not sure if it will give you all that you need, but you can try to query the ReportServer database itself. Some tables that might help are Users, Roles, Catalog, PolicyUserRole, and so on.

 

[fuzzyocelot]

Here's a quick query I put together that might help. I probably should have started out with the Users table as the main table.

select c.[Name], c.[Type], r.RoleName, u.UserName
from catalog c
join PolicyUserRole p on c.PolicyId=p.PolicyId
join Roles r on p.RoleId=r.RoleId
join Users u on p.UserId=u.UserId
where name <> ''
order by u.UserName, c.[Name]

 

[ptheriault]

That's a great start! Thanks Fuzzy!

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[fuzzyocelot]

You are very welcome!