RLS Policies blocking inserting data

[jahodadev]

Hi, I am currently working or registration page. Everything works fine - with disabled RLS I can normally insert data into database. But with RLS on, it always shows error and I have figured out that it is because of the RLS. I have tried the RLS Policy but that also didnt work.

Is there something else that you think would help?

[GaryAustin1]

You would need to show your insert and your RLS policy to get any advice.

[jahodadev]

Here it is

[GaryAustin1]

If you are doing signUp with the option that requires confirming the email (default) then there will not be a user session just a user object after the call. Because there is not a user session there is no user access_token/jwt. So the operation is done as anon role. Auth.uid() will be null for anon role. See the info on signUp here: https://supabase.com/docs/reference/javascript/auth-signup

It is normally better to set up your profile/user table using this guide with an auth.users trigger function. https://supabase.com/docs/guides/auth/managing-user-data