42501

מה אומרת שגיאת Postgres ‏(מסד הנתונים) הזאת

איך זה מופיע

new row violates row-level security policy for table "<table>"

מה זה אומר

SQLSTATE 42501 is insufficient_privilege: the current database role is not allowed to do what the query asked on this table.

הסיבה הנפוצה באפליקציה שנבנתה עם AI

Supabase tables created by AI tools usually have row level security turned on, but the generated SQL often has no policy that allows insert or update for signed-in users, so every write from the app is refused.

בדקו את זה קודם

In the Supabase dashboard, open the policies for the table named in the error and check that one of them allows this action (insert, update or delete) for the role your request uses.

עוד קודים של Postgres ‏(מסד הנתונים)