X
Report PermissionsThis Post/Article/Information has been copied from Intenet with Due Credit given to Original Post Owner.
This post is copied only for information/Knowledge purpose.
Please see the Staring of this post for Original location.Please See the
Desclaimer
Report Permissions A reader of this blog asked me this morning: "If you wanted to design a query to make a report for management that would show which AD Groups or users have access to which reports, how would you go about it." This is what I quickly whipped up:
SELECT Catalog.Name
ReportName ,
Users.UserName ,
Roles.RoleName
FROM [dbo].[Catalog]
JOIN dbo.PolicyUserRole ON [Catalog].PolicyID = PolicyUserRole.PolicyID JOIN dbo.Users ON PolicyUserRole.UserID = Users.UserID JOIN dbo.Roles ON PolicyUserRole.RoleID = Roles.RoleID
Can anyone see any problems with that?
Tags: SSRS 2008