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

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);

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?

Supabase•13mo ago•

4 replies

okan

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

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);

If I put

true

true

My RLS works for select but does not work for delete

Similar Threads

My RLS works for select but does not work for delete

Similar Threads

Similar Threads

Similar Threads