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 staat uit. Je website bevat de publieke sleutel van je database, dus iedereen die hem uit de broncode haalt, kan alle offertes lezen en aanpassen.
Voorstel
alter table offertes enable row level security;create policy "eigen offertes" on offertesfor all using (auth.uid() = owner_id);