Bucket RLS works for Insert but not Update

I have following code in my server function

const { data, error } = await supabase.storage.from('user_avatar').update(`${id}/avatar.${avatar.name.split('.').pop()}`, avatar,{
        upsert: true,
    });

const { data, error } = await supabase.storage.from('user_avatar').update(`${id}/avatar.${avatar.name.split('.').pop()}`, avatar,{
        upsert: true,
    });

and it throws me

Error: new row violates row-level security policy

Error: new row violates row-level security policy

when I try to update user avatar but not on initial upload.
My RLS for insert and update on the bucket are the same:

((bucket_id = 'user_avatar'::text) AND (( SELECT (auth.uid())::text AS uid) = (storage.foldername(name))[1]))

((bucket_id = 'user_avatar'::text) AND (( SELECT (auth.uid())::text AS uid) = (storage.foldername(name))[1]))

Supabase•15mo ago•

2 replies

Floppy Disk

Bucket RLS works for Insert but not Update

I have following code in my server function

const { data, error } = await supabase.storage.from('user_avatar').update(`${id}/avatar.${avatar.name.split('.').pop()}`, avatar,{
        upsert: true,
    });

const { data, error } = await supabase.storage.from('user_avatar').update(`${id}/avatar.${avatar.name.split('.').pop()}`, avatar,{
        upsert: true,
    });

and it throws me

Error: new row violates row-level security policy

Error: new row violates row-level security policy

when I try to update user avatar but not on initial upload.
My RLS for insert and update on the bucket are the same:

((bucket_id = 'user_avatar'::text) AND (( SELECT (auth.uid())::text AS uid) = (storage.foldername(name))[1]))

((bucket_id = 'user_avatar'::text) AND (( SELECT (auth.uid())::text AS uid) = (storage.foldername(name))[1]))

Bucket RLS works for Insert but not Update

Similar Threads

Bucket RLS works for Insert but not Update

Similar Threads

Similar Threads

Similar Threads