Finding 1 of 11
Severity: critical
Anyone can read every invoice, without an account
- What
- The
invoicestable has no row level security. With the public key your website ships, someone without an account can fetch the whole table: 1,240 rows with name, email, address and amount. - Where
- Supabase project
app-prod(eu-central-1), tablepublic.invoices. Requested withGET /rest/v1/invoices?select=*, not logged in. - Why it matters
- This is your customers’ personal data. If someone else has already fetched it, that is a data breach you report to your data protection authority within 72 hours. The API logs for the past 7 days show only our own test.
- Fix
-
alter table public.invoices enable row level security; create policy "own invoices" on public.invoices for all using (auth.uid() = owner_id);Then run the same request again without logging in: you should get an empty list. Effort: about 30 minutes, test included.
Sinto Labs
Row level security is off. Your website ships the public key to this database, so anyone who copies it from the page source can read and change every quote.
Suggested change
alter table quotes enable row level security;create policy "own quotes" on quotesfor all using (auth.uid() = owner_id);