How to grant access to all reports in a Report Server (SSRS 2005) to a specific user domain.

• erasmom1

  SSC Enthusiast

  Points: 187

  More actions

  July 31, 2009 at 7:23 pm

  #385098

  Hi, i have a user that need to view all reports in a report server ( SSRS 2005 ), but the reports are in a folder tree.

  I don't not like the idea to grant access to a every item inside the folders there is a lot of items! I wonder if there is another way to do this.

  Do you know how to grant access in a faster way like grant access with TSQL on the tables of the ReportServer DB or with a special group or things like that ?

  I really appreciate yout help. Thanks in advance. Regards.

  Erasmom

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  August 1, 2009 at 7:57 pm

  #1033418

  You could create a new folder and add this user to this new folder and add the reports you want the user to acccess in this folder.

  Kind regards,
  Gift Peddie

• Marianne L Collins

  SSCommitted

  Points: 1895

  More actions

  August 19, 2009 at 10:21 pm

  #1041935

  If the person needs access to every report, just grant the access at the "home" level. you can do this from the web interface.