Query to find who has access to a report folder or a particular report in SSRS2008 R2?


SELECT
            distinct(C.Path),
            U.UserName
FROM
            Catalog C
INNER JOIN
            PolicyUserRole PUR
            ON
            C.PolicyID = PUR.PolicyID
INNER JOIN
            Users U
            ON
            PUR.UserID = U.UserID
           
SELECT
            distinct(C.Path),
            U.UserName
FROM
            Catalog C
INNER JOIN
            PolicyUserRole PUR
            ON
            C.PolicyID = PUR.PolicyID
INNER JOIN
            Users U
            ON
            PUR.UserID = U.UserID where Path like '/POC/Farm Dashboard POC'

Comments

Post a Comment

Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)