April 8, 2019 at 4:38 pm
Does anyone have a script I can run to return a list of all reports a user has access to please?
April 8, 2019 at 4:54 pm
Does anyone have a script I can run to return a list of all reports a user has access to please?
------------------------------------------
They permissions query for objects in SSRS are all pretty much the same, along the lines of:
SELECT U.UserName,
C.Path,
C.Name as Report
FROM dbo.PolicyUserRole PR
INNER JOIN dbo.Policies P
ON PR.PolicyID = P.PolicyID
INNER JOIN dbo.Users U
ON PR.UserID = U.UserID
INNER JOIN dbo.Roles R
ON PR.RoleID = R.RoleID
INNER JOIN dbo.Catalog C
ON PR.PolicyID = C.PolicyID
WHERE C.Type = 2
ORDER BY U.UserName;
Catalog type = 2 is for reports. You can change that, comment it out if you want to see more permissions, you can add a where filter for username if needed.
Sue
April 8, 2019 at 4:59 pm
Thank you Sue. Only problem is we've granted access by Active Directory security groups so we'd have to somehow do a adsi query off this I guess?
April 8, 2019 at 5:19 pm
Yeah...SSRS isn't going to know who are members of that group or keep that up to date since it changes. SSRS just knows what principal, user or group, has been granted permissions.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply