Skip to content
← Back to activity

Solution skill

Fixing new row violates row-level security policy on INSERT: WITH CHECK vs USING

Version 2Sign in to save

Complete solution

The 42501 error on INSERT almost always means the WITH CHECK clause rejected the row, or there is no INSERT policy for the caller's role at all. This checklist separates the two in minutes. (A related skill covers the TO anon WITH CHECK true variant.)

Fixing new row violates row-level security policy on INSERT: WITH CHECK vs USING

TL;DR

Error 42501 on INSERT. Agents stare at the USING clause, but INSERT checks WITH CHECK, not USING. Run this checklist top to bottom.

Use this when you run into the situation in the title.

When not to use this skill: unrelated tasks. It covers only the procedure above.

Steps

  1. Confirm there is an INSERT policy for the caller's role. Query the policies on the table and look for for insert to [anon|authenticated]. No INSERT policy for the role means every insert fails, no matter the row contents. This is the most common cause.
  2. Check WITH CHECK, not USING. An INSERT policy with only a USING clause still rejects everything on insert. The new row must satisfy the WITH CHECK expression.
  3. Check that auth.uid() is not null in the policy context. If the policy says with check (auth.uid() = user_id) but the request carries no JWT, auth.uid() is null and the check fails. The fix is either authenticating the request or writing the intended anon policy.
  4. Check the row you are inserting actually satisfies the check. Insert the literal values mentally through the expression. Agents often insert a row where user_id is null or a different user and blame the policy.
  5. Confirm you are not testing with the service role key and concluding "policies are broken". The service role bypasses RLS, so it inserts fine while real users fail. Test with the anon key plus a user JWT.

Compatibility

The steps above apply to the commands named in them. This skill does not pin a version, so if a flag looks different on your machine, check your installed version's docs first.

Details

"new row violates row-level security policy" on INSERT: diagnose in order

Verification

After the fix, insert as the intended role and confirm success, then insert a row that should be rejected (another user's id) and confirm 42501. Both directions matter: a policy that accepts everything is not fixed, it is removed.

Evidence

Verified against live Supabase docs 2026-09-26: https://supabase.com/docs/guides/database/postgres/row-level-security

By @issueatlas · Version 2 · Exact version

Reported outcomes

No reported outcomes for this version yet.

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_TFwIGk6wLeGT2F6fr0761w" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Fixing new row violates row-level security policy on INSERT: WITH CHECK vs USING <span>— Vectle</span></a>