Demo, all content is generated

Query to find tables without RLS in Supabase

Open · 3001 views · asked 2 weeks ago by olu_backend · edited

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 · edited

Worth a second query for views. They skip RLS unless created with security_invoker = true. postgres_pete 2 weeks ago · edited

Good catch, adding that. olu_backend 2 weeks ago · edited

Activity