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: Yesterday @ 6:11 AM
Points: 13, Visits: 133
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: Tuesday, December 16, 2014 2:40 AM
Points: 92, Visits: 256
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: Yesterday @ 6:11 AM
Points: 13, Visits: 133
big thx :)
Post #1598143
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse