Have you ever needed to know which groups or users have access to your reports?
Use the following query to get a comprehensive list of who has access to what.
USE ReportServer GO select u.UserName, r.RoleName, r.Description, c.Path, c.Name from dbo.PolicyUserRole pur inner join dbo.Users u on pur.UserID = u.UserID inner join dbo.Roles r on pur.RoleID = r.RoleID inner join dbo.Catalog c on pur.PolicyID = c.PolicyID order by u.UserName
Sample output (fist 4 lines from my test machine):
UserName | RoleName | Description | Path | Name |
BUILTIN\Administrators |
Browser |
May view folders, reports and subscribe to reports. |
|
|
BUILTIN\Administrators |
Browser |
May view folders, reports and subscribe to reports. |
/BT Demo |
BT Demo |
BUILTIN\Administrators |
Browser |
May view folders, reports and subscribe to reports. |
/BT Demo/Computer Information for a specific computer |
Computer Information for a specific computer |
BUILTIN\Administrators |
Browser |
May view folders, reports and subscribe to reports. |
/BT Demo/Server Uptime Report |
Server Uptime Report |
Thanks for sharing this!
Is it possible to determine the date/time a user was grant access to a report?
Perfect, Just what I was looking for