Last post Aug 20, 2016 04:40 PM by Chris Zhao
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?
Aug 20, 2016 04:40 PM|Chris Zhao|LINK
Provide some key information so far we don't know what you're going to do.