Free check

Did your grant fix open your tables?

Since Oct 30, new Supabase tables need a GRANT before the Data API can reach them. A common quick fix is to grant access to anon. Without Row Level Security that makes every row public. We do not read your GRANT statements. We test the result from outside with your public key, read-only: which tables does a stranger get an answer from? We count rows, we never download them.

The 4 most common grants problems

CRITICAL

A table with personal or payment data that anyone can read

After a grant to anon with RLS off, a table named like users, profiles, orders or messages answers a stranger with a row count. Runs after you verify you own the app. We only count rows.

CRITICAL

A Supabase secret or service_role key in your browser code

Some people paste a secret key into the app to get around permission denied. It skips all protection. The free scan checks this.

HIGH

Any other table that now answers a stranger

The same test for every other table we can find in your project and in your site code. Runs after you verify.

HIGH

A storage bucket that lists its files

A bucket named in your site code answers a file listing without login. Runs after you verify.

How to fix them

  1. 01Run the free scan, then verify you own the app so the table checks can run.
  2. 02For each table we name, turn on Row Level Security and add a policy before you keep the grant to anon.
  3. 03If you granted access to anon only to make an error go away, grant it to authenticated and let RLS filter the rows.
  4. 04Scan again to see that the table no longer answers a stranger.

Questions

Do you check my GRANT statements?

No. We do not have access to your database settings. We test what a stranger can actually read with your public key, which is the result that matters.

Do I need to give you access to Supabase?

No. We only need your app's public web address.

What does permission denied for table (42501) mean?

Your table has no grant for the role the request uses. Our Oct 30 post explains the exact SQL and why Row Level Security still matters.

Which checks need me to prove I own the app?

The table and bucket checks. They run after you add a small marker to your site, and then they are free.

Scan your app free

Read more:The Oct 30 grants change, explainedSupabase RLS in plain English
Other tools:LovableCursorBoltReplitv0