Wednesday, October 10, 2012

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'

1 comment:

MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables

  Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...