Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Add permision to report via database Expand / Collapse
Author
Message
Posted Thursday, July 31, 2014 1:44 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 19, 2015 7:49 AM
Points: 384, Visits: 165
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?
Post #1598127
Posted Thursday, July 31, 2014 2:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 22, 2015 6:52 AM
Points: 100, Visits: 317
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
Post #1598138
Posted Thursday, July 31, 2014 2:58 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 19, 2015 7:49 AM
Points: 384, Visits: 165
big thx :)
Post #1598143
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse