Query to determine user has access to report RSS

• • Reply
  krisrajz

  Participant

  1042 Points

  658 Posts

  Query to determine user has access to report

  Aug 18, 2016 08:15 PM|krisrajz|LINK

  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?

  Regards,
  Raj
  
  Remember to click Mark as Answer on the post that helps to others.
  
• • Reply
  Chris Zhao

  All-Star

  17652 Points

  3510 Posts

  Re: Query to determine user has access to report

  Aug 20, 2016 04:40 PM|Chris Zhao|LINK

  Hi Krisrajz,

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

  Best Regards,

  Chris