2 ms·
Multi tenancy applications that use a single database to store the data of multiple organisations (for example CRM data) require strong isolation between tenant
by andrewstuart 11y ago
Multi tenancy applications that use a single database to store the data of multiple organisations (for example CRM data) require strong isolation between tenants. It is much more reliable and makes for a more simple system if the isolation is enforced as a database policy rather than saying to the developers "OK folks, can everyone please never, ever write a query that doesn't properly WHERE the correct client. No bugs ever please for the lifetime of this software. Thanks!"