>I am looking for a way either in SQL or .NET to do the following:
>
> **Need to implement source code to go to the Report Manager and get only the reports the end-users is authorize to see.
>
>Your assistance would be greatly appreciated.
>
>
>Winfred Majors


Hi, Winfred,

Since SSRS stores all definitions in the ReportServer database, you can use SQL code. Here's a script that will return all the information on what's been deployed. Take a look at the results and see how you can filter this down based on your needs. I didn't write this code - there are many versions of it floating around on websites and blogs that talk about this issue. So run this SQL query against your ReportServer database instance.

select C.UserName, D.RoleName, D.Description, E.Path, E.Name 
from dbo.PolicyUserRole A
   inner join dbo.Policies B on A.PolicyID = B.PolicyID
   inner join dbo.Users C on A.UserID = C.UserID
   inner join dbo.Roles D on A.RoleID = D.RoleID
   inner join dbo.Catalog E on A.PolicyID = E.PolicyID
order by C.UserName