Sheet A-S05 · Multi-tenant SaaS

Tenancy is a database
decision.

ArchitectureRLS · audit trail

Multi-tenancy that is bolted on at the application layer is the kind of decision that is invisible until your first cross-tenant data leak. Tenancy is a database decision, made on day one, not on day three hundred when the wrong customer sees the wrong row.

Data Protection Plan 1 — enforced at the row.

Row-level security policies on every table that holds tenant data, with the tenant predicate verified by automated tests on every deploy.
Separate authentication scopes per tenant. JWT claims encode the tenant identity; the database enforces the boundary.
A documented audit trail of every privileged operation, with a retention policy aligned to your regulatory environment.
A written architecture document at hand-over that describes how Plan 1 is implemented, audited, and renewed.

Optimization Plan 1 — cache-first, offline-default.

Cache-first rendering. IndexedDB-first UI. Non-blocking realtime. Aggressive query invalidation reduction. The platform feels fast not because the network is fast, but because the platform was drawn under the assumption that the network would be slow.

When you need this — three triggers.

You are launching a SaaS where tenant isolation is a regulatory requirement, not a nice-to-have. You are migrating off a single-tenant product because customers are asking for white-labelling, regional deployment, or audited segregation. You have built a SaaS already and are drowning in workarounds for tenancy decisions made too late.