I want to make a permission change for someone at the top level of SQL Server Reporting Service and have it trickle down to each folder and report, this is automatic if that folder/report is set to inherit but if it is set to override then it does not. We have hundreds of reports that this 1 permission has to be changed for and I don' want to revert customer permissions on the reports. How can I push this permission change to all the folders and reports?
asked Aug 17, 2016 at 19:50
-
I think this has already been answered here– Shooter McGavinAug 24, 2016 at 22:12
-
@ShooterMcGavin Thanks but I don't want to revert to partent permissions as that will override the custom permissions of all the reports. I need to figure out a way to push a single change from parent to all children.– Matthew VerstraeteAug 25, 2016 at 12:43
Add a comment
|
1 Answer
@Matthew, Given that you do not want to revert to parent security on your sub-folders and children reports, I think your only option will be to write some custom code which accesses the SSRS Web Services API. I've done something similar using powershell for one project and a C# script task from SSIS for a different project and should work well although it won't be accessible from the SSRS management portal.
I'm 99% certain that there is no functionality within SSRS that will directly handle your request out of the box.
-
I am not against writing some custom code. When you where doing yours did you run across any good documentation you would recommend me checking out? Aug 25, 2016 at 19:42
-
1