I often need to document the access that various users have to content stored in SQL Server Reporting Services (SSRS). Surprisingly, I didn't find any built-in way to do that.
We had started to add some Reporting Services related options to our free SDU Tools for developers and DBAs, and, just for this, we added a new procedure RSListUserAccessToContent.
It takes two parameters:
@IsOrderedByUserName bit -> Is the output ordered by user (default yes else by item)
@RSDatabaseName sysname -> Reporting Services DB name (default is ReportServer)
The output has the following columns: UserName, RoleName, PathName, FolderName, ItemName, ItemType.
You can see the procedure in action in the image above, and in the video here:
To become an SDU Insider and to get our free tools and eBooks, please just visit here: