SQL query help needed to set tag permissions

[neomaven]

My forum has ~185 forums and subforums, and 20 or so usergroups.

We had some problems with members abusing the thread tagging option, and I would like to change permissions for many of those usergroups regarding Tags to the following:

Can tag own threads: Yes
Can tag others' threads: No
Can delete tags on own threads: Yes

I need help construcing an SQL query to set such permissions for each usergroup in every forum, since I really do not relish the prospect of making all those changes by hand in the admin CP.

[Jose Amaral Rego]

No safer method other then using this option. It would be nice to select multiple groups and apply permission settings to each forum at one place.
Forums & Moderators / Usergroups > Forum Permissions > Additional Functions > ?

[neomaven]

Yes I agree, there really should be an easier way to change permissions for multiple usergroups in multiple forums. This method is extremely tedious :(

Perhaps there is a handy SQL query that would set ALL tag permissions to NO for all usergroups in all forums, and then I can simply go back and enable tag permissions for the groups I wish to give access?

This would be much less work than the opposite, since unfortunately the default for all groups when installing 3.7 is set to yes.