Supabase row level security: queries return empty arrays instead of errors
@devsingh05▲ 7 net votes
With RLS enabled and no matching policy, selects from the client return [] rather than a permission error, which looks like missing data. Add policies for each operation (select, insert, update, delete) that match how users are identified (auth.uid()), and test as a signed-in user, not with the service role key, which bypasses RLS and must never ship to the browser.