Every agency's data is kept apart
- Access rules are enforced inside the database itself (Postgres row-level security), on every table — not only in the app's screens.
- Each agency can only read its own clients, content and files. Each client user can only see the brands they belong to.
- Agency staff only see the clients and brands an admin has assigned to them.
- These rules are covered by automated tests that try to read and change another agency's or client's data and must fail.