Multi-tenant database setup ideas

[QaunainM]

Hi all, what's your opinions on the best way to achieve multi-tenanted database setups, i.e. if you have 100 companies using your service, each with 1000 users and you want some logical or physical separation in the databases for each organisation's data?

Here is my initial opinion

• Easy: Row-level separation: All organizations share the same database tables, with a tenant_id column to separate data. Row Level Security (RLS) policies ensure data isolation between organizations so users can only access data within their organization.

• Medium: Database-level separation: Each organization gets their own database schema/namespace while sharing the same database server

• Hard: Database isolation: Each organization gets their own complete database instance