Supabase bucket - new row violates row-level security policy for table "objects"

Question

I am having an issue with uploading avatars to my supabase bucket as its giving me "new row violates row-level security policy for table "objects"". I tried other StackOverflow solutions and nothing. Before trying to upload I log in using supabse so my user is authenticated yet its still not letting me upload. I added this policy in storage.objects:

(role() = 'authenticated'::text) and clicked the insert button. Does anyone know what I am doing wrong? I assume its something to do with the policies. Thanks

This is how I'm trying to upload my avatar:

try {
  const { data, error } = await supabase.storage
    .from("/public/avatars")
    .upload(`${values.email}.png`, values.avatar, {
      cacheControl: "3600",
      upsert: true,
    });
  if (error) throw error;
} catch (error) {
  console.log(error);
}

Juan Silupú Maza · Accepted Answer · 2022-11-16 22:29:59Z

55

add new policy and enjoy :)

Because upsert need DELETE and UPDATE

answered Nov 16, 2022 at 22:29

Juan Silupú Maza

1,08110 silver badges8 bronze badges

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

3 Comments

Brady Dowling Over a year ago

This is terribly permissive, basically allowing auth'd users to do anything they want to the bucket to any folders.

Ben Neighbour Over a year ago

@BradyDowling I agree that this dumbed-down example is, but in the SQL expression you can do far more, such as verifying the user authenticated's role, etc. Supabase is pretty powerful like that.

Mahmoud Mousa Hamad Over a year ago

The image does not show...

thorwebdev · Accepted Answer · 2022-11-07 06:37:42Z

1

I'm guessing you have a bucket named public with a folder named avatars, correct?

In that case you would upload as follows:

const avatarFile = event.target.files[0]
const { data, error } = await supabase
  .storage
  .from('public')
  .upload(`avatars/avatar1.png`, avatarFile, {
    cacheControl: '3600',
    upsert: false
  })

answered Nov 7, 2022 at 6:37

thorwebdev

1,2327 silver badges11 bronze badges

1 Comment

M. Mariscal Over a year ago

In Supabase i see it has 15kb all the uploaded pictures, how did you fix it?

Hafiz DotTeck · Accepted Answer · 2023-12-18 16:51:01Z

1

I had the same problem! In Next.js the solution is to use "supabase" instance of auth-helpers ex: const supabase = createServerActionComponentClient({cookies}); instead of the normal supabase client created from key & url.

answered Dec 18, 2023 at 16:51

Hafiz DotTeck

111 bronze badge

1 Comment

Ala Eddine Menai Over a year ago

Could you share an example?

Collectives™ on Stack Overflow

Supabase bucket - new row violates row-level security policy for table "objects"

3 Answers 3

3 Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related