Add permision to report via database

• krzysztof.ostrowski

  SSCrazy

  Points: 2909

  More actions

  July 31, 2014 at 1:44 am

  #297212

  Hi, I have many reports [over 300] and about 2500 users. Is it posible to automaticly add permission [browser] to specific person? I'm going to create table with data:

  person login | report name | report path | . I thing about create job, get data from table and insert / update it on reportserver database

  Any idea?

• MrG78

  Default port

  Points: 1482

  More actions

  July 31, 2014 at 2:31 am

  #1733951

  You can do this by using the RS.exe utility.

  Here's a link to a document that provides a script similar to what you want to do

  http://www.chrisumbel.com/article/ssrs_scripting_with_rs_exe.aspx

• krzysztof.ostrowski

  SSCrazy

  Points: 2909

  More actions

  July 31, 2014 at 2:58 am

  #1733956

  big thx 🙂