Unauthorized: new row violates row-level security policy - while uploading to supabase storage

Question

I am working with a project which needs to use python to store the jpg file into supabase storage. But I am getting an error:

Failed to upload file:
b'{"statusCode":"403","error":"Unauthorized","message":"new row violates row-level security policy"}'

I have set up the RLS policies in Supabase project and also given necessary permissions to Supabase Storage to upload files.

Here is my code:

file_path = r"C:\supabase projects\supabase auth 24-01-2024\uploads\test.jpg" file_name = "test.jpg" path_on_supastorage = "uploaded_files/test.jpg" content_type = "image/jpg" with open(file_path, 'rb') as file: response = supabase.storage.from_(bucket_name).upload( file=file, path=path_on_supastorage) # Check for successful upload if response is not None: print(f"Failed to upload file: {response.content}") else: print(f"File uploaded successfully: {response}")

What is the cause of this problem exactly?

My hunch is that your policy is incorrect. See the docs here: supabase.com/docs/guides/storage/security/… Would be useful to update your question to include which policies you have created. — thorwebdev
– thorwebdev, Commented Feb 6, 2024 at 4:14

Solovastru Ioan · Accepted Answer · 2024-02-13 10:09:33Z

5

I had a similar issue and my first try was to switch to public. However, the fix is to leave it private and create a policy like the following:

answered Feb 13, 2024 at 10:09

Solovastru Ioan

1851 silver badge7 bronze badges

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

2 Comments

M. Mariscal Over a year ago

its not working... :(

Solovastru Ioan Over a year ago

Can you tell me more about your setup?

laiki · Accepted Answer · 2025-07-26 16:11:12Z

try

mime_type, _ = mimetypes.guess_type(file_path) response = supabase.storage.from_(bucket_name).upload( file=file, path=path_on_supastorage, file_options={ "headers" : { "content-type" : mime_type} })

this helped me

Collectives™ on Stack Overflow

Unauthorized: new row violates row-level security policy - while uploading to supabase storage

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related