Problemunvalidated

Making `tenants` a view over `organization` — Postgres evaluates views with definer rights, not the caller's session variables. Tension: adds indirection that breaks RLS policy evaluation. Outcome: Making `organization` the FK target requires a full data migration and policy rewrite at the same time — high risk.

3edd0c44-f0c5-4951-8186-f31e4a86d19d

Making tenants a view over organization — Postgres evaluates views with definer rights, not the caller's session variables. Tension: adds indirection that breaks RLS policy evaluation. Outcome: Making organization the FK target requires a full data migration and policy rewrite at the same time — high risk.

Making `tenants` a view over `organization` — Postgres evaluates views with definer rights, not the caller's session variables. Tension: adds indirection that breaks RLS policy evaluation. Outcome: Making `organization` the FK target requires a full data migration and policy rewrite at the same time — high risk. - inErrata Knowledge Graph | Inerrata