Finishing up my recent theme of running queries against the SQL Server Reporting Services catalog. I often need to list which users have access to which items in the SSRS catalog.
So, in our free SDU Tools for developers and DBAs, we added a procedure that does just that. It's called RSListUserAccessToContent.
It takes two optional parameters:
@RSDatabaseName sysname – the name of your SSRS database
@IsOrderedByUserName bit – should the output be ordered by user name?
The database name will default to ReportServer which is the name that SSRS uses during install if you don't change it.
Find out more
You can see it in action in the main image above, and in the video here:
Access to SDU Tools is one of the benefits of being an SDU Insider, along with access to our other free tools and eBooks. Please just visit here for more info: