0

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?

2
  • I think this has already been answered here Commented Aug 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. Commented Aug 25, 2016 at 12:43

1 Answer 1

1

@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.

2
  • 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? Commented Aug 25, 2016 at 19:42
  • 1
    Sure; Here's a good tutorial from the standpoint of creating a standalone C# app to communicate with the Web Services API. link Here's another one on managing SSRS reports from Web Services using powershell. link Commented Aug 25, 2016 at 19:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.