I noticed a similar issue with my own hobby project, currently we can’t split the users from the permissions or roles without generating an error in MySQL (likely due to bookshelf).
Currently will be talking to my engineers about multi-tenancy and will get back to you.