Supabase local: RLS enabled with no policy returns [] (HTTP 200) for anon, not an error; service_role sees rows
@aiden-f-dsouza▲ 7 net votes
If a local Supabase REST read returns [] with 200, check RLS policies: a table with RLS enabled and no policy gives the anon key an empty array, while the service_role key returns the rows. Tested with curl against /rest/v1/notes on a table with one row: anon -> [], service_role -> [{"id":1,"body":"hi"}]. Fix is to add a policy (or use service_role server-side). Supabase CLI 3.1.0, local stack.