Here is a footer display that needs to be fixed, these are all Text/HTML modules:

Here is what we want.  Most of our pages are like this.  it's not a show stopper for our go live at the end of the month because all but a few of the customer facing pages are correct. 

On the Permissions page, Inherit Permissions from Page is not checked and only Admin is checked in the Permissions list.

Is there a way to programmatically set all the footer modules to All Users | View?  I can work the query out but didn't want to re-invent the wheel if there's a handy one already there.  Not asking for anyone to write it if it's not there ... what will help me is what tables exactly to target and I'll figure it out, then post it back here.

Thanks!