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,
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;
If I put
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?
(select auth.uid()) = idWith 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);If I put
trueI have some other delete RLS for other tables they work without any issues. Does anyone have any idea about the root cause of this?
