Guides
One page per error, task and builder tool.
- 42501: permission denied for tableThe role has no grant on the table. Paste the error or your table and get the SQL.
- Supabase table not exposed to the Data APIA new table is invisible to the API until a role is granted access. Here is the grant.
- New Supabase table not showing in the APITwo checks tell you if the grant is missing. Then fix it below.
- The Supabase change of 30 October 2026New tables in public need explicit grants. Dates, scope and the SQL in one place.
- Every cause of 42501 on Supabase42501 means "insufficient privilege". Match your message to a row.
- Grants for anon, authenticated and service_roleThree roles, four privileges. This is the grid the tool fills in.
- Is my Supabase project affected?Run one query. No rows means new tables get no grants.
- Grants vs row level securityTwo checks run on every request. A grant comes first.
- Lovable app says "permission denied for table"The new table has no grants. Paste it below and copy a fix prompt made for Lovable.
- Bolt app says "permission denied for table"The new table has no grants. Paste it below and copy a fix prompt made for Bolt.
- Replit app says "permission denied for table"The new table has no grants. Paste it below and copy a fix prompt made for Replit.
- "Grant the required privileges to the current role with: GRANT ..."The hint names one missing grant. Paste it and get the full set.
- permission denied for sequenceThe table is granted and its id counter is not. One more grant fixes it.
- Go back to automatic exposureSupabase documents the SQL. Read what it re-opens before you run it.
- Public read-only tableAnyone reads. Only your server writes. Here is the SQL.
- Owner-only tableEach signed-in user sees and changes only their own rows.
- Private, server-only tableNo access from the browser. Your server reads and writes.
- Check the grants on a tableOne query lists every role and privilege on a table.
- Local tables missing grants after db resetA reset replays your migrations. Without grants in them, tables come back closed.