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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 20, 2014 6:39 AM
Points: 11, Visits: 109
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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 16, 2014 7:20 AM
Points: 87, Visits: 240
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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 20, 2014 6:39 AM
Points: 11, Visits: 109
big thx :)
Post #1598143
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse