Query to find tables without RLS in Supabase

Open · 3001 viewsasked 2 weeks ago by

Run this in the SQL editor after every Lovable or Bolt session. Empty result = good.

Copied 13 times

select schemaname, tablename
from pg_tables
where schemaname = 'public'
  and rowsecurity = false
order by tablename;

Ran it. Four tables. Four!

noor_builds 2 weeks ago

Worth a second query for views. They skip RLS unless created with security_invoker = true.

postgres_pete 2 weeks ago

Good catch, adding that.

olu_backend 2 weeks ago

Activity