C#C
C#3y ago
Tandy

❔ 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
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?
Was this page helpful?