All geek questions in one place

SQL Server Reporting Services 2008 R2 - Folder and Report Security

Is there any way to specify (using an SSRS report or query via SQL code) the Username or Group security that was assigned to the root folders, subfolders, or reports?

I was asked to identify the audience in which AD groups have access to all root folders and subfolders in this root folder or even to a separate report level - who has access!

How to fulfill this request?

+6
source share
1 answer

You can query the ReportServer database for this information, for example

 SELECT CASE [Catalog].[Type] WHEN 1 THEN 'Folder' WHEN 2 THEN 'Report' WHEN 3 THEN 'Resource' WHEN 4 THEN 'Linked Report' WHEN 5 THEN 'Data Source' WHEN 6 THEN 'Report Model' WHEN 8 THEN 'Shared Dataset' WHEN 9 THEN 'Report Part' END AS CatalogType, [Catalog].[Type] --, [Catalog].ItemID ,[Catalog].Name , Roles.RoleName , Users.UserName FROM PolicyUserRole INNER JOIN Roles ON PolicyUserRole.RoleID = Roles.RoleID INNER JOIN Policies ON PolicyUserRole.PolicyID = Policies.PolicyID INNER JOIN Users ON PolicyUserRole.UserID = Users.UserID INNER JOIN [Catalog] ON PolicyUserRole.PolicyID = [Catalog].PolicyID ORDER BY 1 , [Catalog].ItemID , [Catalog].Name , Roles.RoleName , Users.UserName
+12
source

Source: https://habr.com/ru/post/946512/

More articles:


All Articles