My model has organisations and users. Users can be invited to access multiple organisations databases. Users get read or read and write access to organisations databases depending on their role for that organisation.
Given this. Should I create a private or shared database when I want organisation wide (but not public) sharing?
How do I configure roles/permissions to set the access type the user has to that database?