Post reply

List of users who have access to reports

  • November 2, 2009 at 5:07 am

    #212748

    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

    #1073799

    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

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • November 3, 2009 at 3:24 am

    #1074194

    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

    #1074202

    Thanks Rekha.

    Thats working fine.

    😎

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply