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.
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:
But how do I find particular user has access to report who is under a group?
Raj
Remember to click Mark as Answer on the post that helps to others.
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