Post reply

Extracting AD Group or User Name for a report

  • July 9, 2008 at 9:03 pm

    #381581

    Hi,

    Need some help on SSRS Security.

    As you know, on the report server, each report/folder has Windows AD Groups or Users assigned to it who can view/consume the report.

    I want to know if there is any way to extract this information programmatically about the Groups or Users who can access the report

    I want the Windows AD group or user name so as to be able to compare it with the Windows AD group of the user logged in to the application we are creating. If these match only then the user should be able to view the report.

    Is there any API which I can use for this? Or if you know any other way also please let me know.

    Any help will be much appreciated!!

  • July 14, 2008 at 5:04 am

    #842294

    Try running this against your ReportServer database:

    SELECT

    c.path,

    r.rolename,

    u.username

    FROM

    catalog c

    JOIN

    policyuserrole p on p.policyid = c.policyid

    JOIN

    users u on p.userid = u.userid

    JOIN

    roles r on r.roleid = p.roleid

    Nigel
    How to post questions

Viewing 2 posts - 1 through 1 (of 1 total)

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