It is rarely "RLS off"
Only 1% of all tables had row level security switched off; platforms now usually create tables with it switched on. The holes moved: policies that allow every signed-in user to read every row, database functions anyone can call, and Edge Functions that skip the login check.
What to check in your app
For every table, ask what a stranger with your public key can read and change, and what any signed-in user can. Both answers should be "only their own rows" unless the data is meant to be public. Then do the same for every database function and server function.
Data: Redproof's automated checks on public GitHub repositories, November 2026. No repository is named. Method and limits