How to get error reporting for Supabase RLS violations?

Question

I am using Supabase's RLS to control which users can delete certain records in the database. The records are associated with files in a bucket that will get deleted too. I expect that if the Supabase delete request fails (i.e. because the RLS policy is violated), I will get an error, and skip the file deletion too... but it turns out that when a request violates RLS, it just returns a 200 Success code and makes no changes to the DB. But then my script has no exception to throw and the files get deleted anyway. Is there any way to get an error when the query fails so that I can skip deleting my files?

      // Delete the file entry from the database
      const { error: deleteError } = await supabase
        .from('files')
        .delete()
        .eq('id', fileId);

      if (deleteError) throw deleteError;

      console.log("Errs", deleterror);
      // Delete the object from R2
      await context.env.MY_BUCKET.delete(fileData.r2_object_name);

Laurenz Albe · Accepted Answer · 2024-09-04 06:35:10Z

0

Row-level security makes it appear that the rows you are no allowed to delete aren't there. Here are some ideas:

check the number of rows deleted and throw an error if it is 0
don't use row-level security, but use a BEFORE DELETE trigger that checks the condition and throws an error

answered Sep 4, 2024 at 6:35

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get error reporting for Supabase RLS violations?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related