Query to find tables without RLS in Supabase

Open · 7 views · asked 3 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;

Activity