November 14, 2008 at 3:47 am
Hello,
Does anybody know how to get a complete list of all available SSRS 2005 reports and related users with their permissions? It’s possible to get this information by going to each report and see its properties separately (either in Report Manager or in SSMS).
But is there a way to get a single report with such information at once for audit purposes?
December 8, 2008 at 10:45 am
Here is what I have used.
select c.[Name], r.RoleName, u.UserName
from reportserver.dbo.catalog c
join reportserver.dbo.PolicyUserRole p on c.PolicyId=p.PolicyId
join reportserver.dbo.Roles r on p.RoleId=r.RoleId
join reportserver.dbo.Users u on p.UserId=u.UserId
where name <> '' and c.Type = 2
order by c.[Name], u.UserName
December 8, 2008 at 11:55 pm
Thank you!
This is what I need.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy