what should my policy look like?

hey guys, if i'm using the auth schema that supabase uses for users table, change a specific user's role to 'admin'. The users are signing up through a provider of that adds anything.

what should my policy look like so that only an admin is able to interact with my bucket?

here's what i have and i can't get it to work when i try uploading:

CREATE POLICY "Give admin users access to folder 1fla722_0" ON storage.objects FOR SELECT TO public USING (bucket_id = 'sign_images' AND auth.role() = 'admin');

CREATE POLICY "Give admin users access to folder 1fla722_0" ON storage.objects FOR SELECT TO public USING (bucket_id = 'sign_images' AND auth.role() = 'admin');

i keep getting the following error when uploading from my page.svelte file:
```"new row violates row-level security p

Supabase•3y ago•

14 replies

Heugh_Jazz

what should my policy look like?

CREATE POLICY "Give admin users access to folder 1fla722_0" ON storage.objects FOR SELECT TO public USING (bucket_id = 'sign_images' AND auth.role() = 'admin');

CREATE POLICY "Give admin users access to folder 1fla722_0" ON storage.objects FOR SELECT TO public USING (bucket_id = 'sign_images' AND auth.role() = 'admin');

i keep getting the following error when uploading from my page.svelte file:
```"new row violates row-level security p

what should my policy look like?

Similar Threads

what should my policy look like?

Similar Threads

Similar Threads

Similar Threads