Programmatically Adding Users To The Report

• Igor Deck

  SSCarpal Tunnel

  Points: 4219

  More actions

  March 5, 2019 at 6:04 pm

  #377146

  Hi everybody,

  I need to give Browser permissions on 5 reports to 20+ users. Is there a way to do it programmatically by running T-SQL script?

  Your help is greatly appreciated.

  Thank you,

  Igor Deck

• Jo Pattyn

  SSC-Dedicated

  Points: 32350

  More actions

  March 6, 2019 at 2:47 am

  #2023633

  You can explore powershell for managing security etc
  https://www.sqlshack.com/managing-ssrs-security-using-powershell-automation-scripts/