RLS Problem

[BardiaAkbari]

this is my function in nestjs

  async delete(id: string) {
    const { data, error } = await this.supabaseClient
      .from('brand')
      .delete() // Specify that you want the deleted row(s) returned
      .eq('brand_id', id);

    if (error) {
      throw new NotFoundException('Brand not found or delete failed');
    }

    if (!data) {
      throw new NotFoundException('No rows deleted. Brand not found');
    }

    return data;
  }

and this is my RLS for deletion:

alter policy "enable delete for users based on user_id"
on "public"."brand"
to authenticated
using (
(auth.uid() = owner_id)
);

I know the id that I send is valid, but in response I get Exception error.
i don't know why it seems everything is perfectly fine

P.S. I try to ignore exception and see maybe it's deleted but no data is return but no, the row of that brand is still there.
what should I done?

P.S. When I disable RLS it is work

THANK YOU FOR YOUR HELPING.

[GaryAustin1]

You also have to meet select RLS for delete to work.

If your select is same policy then likely you don't have a user session when you make the call.

https://github.com/orgs/supabase/discussions/28652