recommend mysql settings

[Matthijspals]

Hi,

We are in the process of setting up a datajoint server (using https://github.com/datajoint/mysql-docker) for the Mackelab and are trying out nnfabrik. If I understood correctly by default the Fabrikant table is shared by all users on the nnfabrik_core schema whereas the other table can be on any other schema accessible by the user.

What mysql permissions do you generally give users on the nnfabrik_core schema? It seems a bit risky to give users all access, so I'm guessing there might be a subset that will still allow users to execute e.g. the example notebooks but not allow them to delete information inserted by other users (and thus the tables depending on that information) in the Fabrikant table.

Thank you very much!