We have answer of your question!

100% solved queries, no empty question

Question: SQL Server Reporting Services 2008 R2 - Folder and Report Security


0

Is there any way I can list (either using a SSRS report or querying through SQL code), the Username or Group security that has been assigned against root folders, sub-folders or reports ?

I've been asked to identify as an audit, which AD groups have access to all root folders and sub-folders within that root folder, or even down to the individual report level - of who has access!

How do I accomplish this request?

Question author Learner74 | Source

Answer


1


You can query the ReportServer database for this information, e.g.

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
Answer author Nathan

Tickanswer.com is providing the only single recommended solution of the question SQL Server Reporting Services 2008 R2 - Folder and Report Security under the categories i.e sql , sql-server , reporting-services , ssrs-2008-r2 , . Our team of experts filter the best solution for you.

Related Search Queries:


You may also add your answer

Thanks for contributing an answer to Tick Answer!