XF 2.2 SQL Query to remove hard delete option from all users/usergroups?

[ekool]

I want to globally remove the hard delete option for all users and usergroups. Is there a query I can run to do this via SQL?

 

[Paul B]

You do that via the user group permissions, not a query.

If your permissions and groups are set up correctly, you just need to do it in the Registered user group.

 

[ekool]

When you set up a Super mod or administrator, you also can individually give them this permission from that page. Is there no way to remove it globally from a query? I can remove it from the usergroups, but you can override that per user. I'm not wanting to manually check out 20 mods on 20 sites to remove it. I'd prefer a query I can run to remove it from everyone, all at once.

Edit: I'm seeing if you put this never on the registered usergroup, it will override the individual perms of the users and groups, is that correct? Assuming all other groups are children of the registered?

 

[Paul B]

but you can override that per user

Never overrides everything.

As long as all members are in the Registered user group, that's all you need to do.

 

[ekool]

Thank you!