Multiple DB, Multiple Strapi Instances, Role Permissions

System Information
  • Strapi Version: 3.5
  • Operating System: Ubuntu 20.04
  • Database: MySql
  • Node Version: v10.19.0
  • NPM Version: v7.5.2
  • Yarn Version: 1.22.5

Hi all,
I’m using Strapi for multiple API’s, and each api has its own DB,
linking on the database.js file the databases which are involved in some of the collections, ie user-permissions.
nginx is setup on using the Subfolder unified setup from the Strapi docs.
My dilemma is the following, every now and again, I get a 403 response, I then need to rebuild the api (else another api’s collections are shown for rights, even if there is no relation to that db whatsoever), run Strapi, and re-setup the roles.
Anyone else found this issue?

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.

any solution on this? facing the same issue. would appreciate your help.

In the v4 we removed multi-database so there won’t be a solution to this.