Post reply

List or available reports and related users with their permissions

  • November 14, 2008 at 3:47 am

    #201345

    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

    #909267

    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

    #909484

    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