Extracting AD Group or User Name for a report

• Ritika Thakkar

  SSC Journeyman

  Points: 99

  More actions

  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!!

• nigel.

  SSChampion

  Points: 11636

  More actions

  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