locked
Query to determine user has access to report RRS feed

  • Question

  • User-1129879462 posted

    I need to get the list reports that a user has access to?

    Is there a way to achieve this by using T-SQL query?

    I have this query:

    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   
    
    

    But how do I find particular user has access to report who is under a group?

    Thursday, August 18, 2016 8:15 PM

All replies

  • User-2057865890 posted

    Hi Krisrajz,

    Provide some key information so far we don't know what you're going to do.

    Best Regards,

    Chris

    Saturday, August 20, 2016 4:40 PM