Pricing Blog

Supabase, workaround for deleting without select RLS?

  • uunicode-1388796270239420416

    unicodes

    18 days ago

    I have a public table and I need workaround for deleting without having a select RLS.
    I can not add select RLS because PostgREST doesn't support filters in RLS, like (you can select only if you provide the id).
  • martinf4630-1389183768161685554

    MartinF

    17 days ago

    I'd create an RPC function and call it like any other API. Will need to be security definer property so it bypasses RLS.