Post reply

SSRS Security Report

  • November 5, 2008 at 3:44 pm

    #195458

    We have an SSRS site with many subfolders and permission assignments via AD group membership. Is there a way to document the security configuration, say, in an SSRS report?

  • November 6, 2008 at 6:54 am

    #894825

    I used this. It only grabs report objects...

    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

  • November 6, 2008 at 7:12 am

    #894835

    Thanks - this will get me started down the right path.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply