Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 23, 2016 2:31 AM
Points: 1,812, Visits: 328
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, April 8, 2016 7:57 AM
Points: 112, Visits: 356
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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 23, 2016 2:31 AM
Points: 1,812, Visits: 328
big thx :)
Post #1598143
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse