userA and userB each have the ability to upload files to a specific folder path.
((bucket_id = 'contract-attachments'::text) AND ((uid())::text = (storage.foldername(name))[2]))
((bucket_id = 'contract-attachments'::text) AND ((uid())::text = (storage.foldername(name))[2]))
what I'm struggling to figure out at the moment, is how to write a policy that would allow both users to select/download each other attachments. I also wonder if there's a way for me to rearchitect these file paths to make the problem simpler
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.