My RLS works for select but does not work for delete

As the title says, I have a simple RLS for profiles table as follows,

(select auth.uid()) = id

(select auth.uid()) = id

(select auth.uid()) = id

(select auth.uid()) = id

With this i can select own profile without any issues but when I want to delete it, i can't delete it. Using the following query;

const { error } = await supabase.from("profiles").delete().eq("id", userId);

const { error } = await supabase.from("profiles").delete().eq("id", userId);

const { error } = await supabase.from("profiles").delete().eq("id", userId);

const { error } = await supabase.from("profiles").delete().eq("id", userId);

If I put

true

true

for select RLS or disable it all it works. So I'm sure that it's related to this RLS.

I have some other delete RLS for other tables they work without any issues. Does anyone have any idea about the root cause of this?

DevsrealmGuy•1/16/25, 11:06 AM

Show the complete RLS of the profile table

okanOP•1/16/25, 1:09 PM

all of them sharing the same logic

garyaustin•1/16/25, 1:47 PM

Try changing that to to anon and true for select and delete (both are required for delete). If that works then you don't have a user session where you are calling the delete. You can also do auth.getSession() right before the call and see if you have a user session.

okanOP•1/16/25, 3:28 PM

I've tried it already and it was fine. Though, thanks to your suggestion I found the race condition that was causing a problem with my user session before i delete the profile. Issue is resolved!

My RLS works for select but does not work for delete

Similar Threads

Similar Threads

Similar Threads