November 2, 2009 at 5:07 am
Hi,
Can somebody help me on how to find out
Names of the reports,List of users who have acess to each report.
The data in execution log won't be helpful,because there might be a case where the user has access rights,but have not executed the report.
November 2, 2009 at 7:13 am
Hi rekha_sara,
You are absolutely right. Data in the execution table won't helpful.
I also think that there is no table holding the value.But it should be somewhere.
Try using web service method. I'll also try.
I'm also looking for solution
November 3, 2009 at 3:24 am
This query will give the result
SELECT Path As Report, UserName,RoleName FROM dbo.Catalog
INNER JOIN dbo.PolicyUserRole
ON dbo.PolicyUserRole.PolicyID = dbo.Catalog.PolicyID
INNER JOIN dbo.Users
ON dbo.Users.UserID = dbo.PolicyUserRole.UserID
INNER JOIN dbo.Roles
ON dbo.Roles.RoleID = dbo.PolicyUserRole.RoleID
WHERE Type = 2
ORDER BY Report,UserName
November 3, 2009 at 3:49 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply