How to protect all categories in bulk

WFA comes with a Cdot pack that contains a bunch of demo workflows.  You can hide them in the portal by going to "administration - WFA configuration - Advanced - show workflows" and then uncheck the packs you don't want to see.

However, from the rest API, these workflows are still visible.  If you truly want to hide them, you should add every workflow to a category and then restrict every category.




If you want to restrict every category in bulk, you can do this by connecting to the MySQL server with "root" and execute this SQL-statement :

UPDATE wfa.category SET used_for_authorization=1

** update **
Now part of maintenance workflow
https://github.com/wfaguy/workflows/tree/master/Wfa%20Maintenance