If your policy is changed to

(auth.role()::TEXT = 'authenticated')

, does it work then?

Hey, just replied to you, i found the issue after all.

Cool. For reference in case anyone else comes looking for the solution: "Ok, found the issue. For whoever might face it. Supabase in order to insert, needs to also have a select permission to the Policy. Otherwise it wont work. If u dont want to add a select policy, simply add this to your insert statement insert(data, { returning: 'minimal' })" (https://discord.com/channels/839993398554656828/843999948717555735/875043429304909845)

Amazing! Btw do u work at supabase?

Nope, just a huge fan of the product because it's better than the competition 🙂

So true! Saves so much time for be stuff and gives a lot of flexibility. Im thinking about building my new saas startup with supabase, but what if they fuck up and disappear? 😛

Yeah, that's definitely a risk with any startup. I hope they don't disappear, but the fact it's all open source (except the dashboard, though there's progress being made in that area too) means self-hosting is always an option.

hosting yeah, but if they go away all authentication and db schemas go away

You used to be able to dump the auth schema in some older Supabase projects, but that's no longer possible from what I can see. It might still be possible to dump the auth data though. You can still dump the public schema and data, and import it to a new server.

Yeah probably, u are right. Thank god its open source haha

A few, but all of them are closed-source commercial contracts with clients. Some startups, some established.

Thats cool! Here is my linkedin if u wanna connect there too