❔ Multi-tenancy - database per tenant - which database(s) to store Users?
We're using Auth0 for authentication. A given User could have access to multiple tenants. I'm envisioning a
However, I imagine that the tenant databases will require user information, like first name, last name, email, etc, for business logic. So does it make sense to have a
Catalog database with Tenants table and Users table, as well as a UserTenants table that links the two.However, I imagine that the tenant databases will require user information, like first name, last name, email, etc, for business logic. So does it make sense to have a
Users table in both the Catalog database but also in each tenant database?