Fixes
Fixes for common errors
Searched for an error message? Start here. Short, tested fixes that keep your security settings on, each linked to the official docs.
- new row violates row-level security policy (Supabase)Your insert or update is blocked by RLS. Add a policy for that exact write, without turning RLS off.
- Supabase returns empty array [] with RLSNo error, no rows: RLS is filtering everything out. Here's how to add the select policy you're missing.
- 42501 permission denied for tableThe table has no GRANT for your role. Add the grant, keep RLS on, and add policies.
- Is my Supabase anon/publishable key safe in the frontend?Yes, it's designed to be public. Your protection comes from RLS. The secret key is a different story.
- How to check if a secret key is in my frontend bundleBuild your app, then search the output for secret keys and service_role tokens. Three tested commands.