Hi,

does this get you started:

To get a list of the top-level folders and associated user permissions:

SELECT Catalog.Name, Catalog.Path, Users.UserName

FROM Catalog INNER JOIN

Policies ON Catalog.PolicyID = Policies.PolicyID INNER JOIN

PolicyUserRole ON PolicyUserRole.PolicyID = Policies.PolicyID INNER JOIN

Users ON PolicyUserRole.UserID = Users.UserID

WHERE (Catalog.ParentID =

(SELECT ItemID

FROM Catalog

WHERE (ParentID IS NULL)))

ORDER BY Catalog.Path, Users.UserName

To get a full breakdown of which users have access rights to reports in Reporting Services:

SELECT Catalog.Path, Catalog.Name, Users.UserName, Catalog.Type

FROM Catalog INNER JOIN

Policies ON Catalog.PolicyID = Policies.PolicyID INNER JOIN

PolicyUserRole ON PolicyUserRole.PolicyID = Policies.PolicyID INNER JOIN

Users ON PolicyUserRole.UserID = Users.UserID

ORDER BY Catalog.Path