Reference Custom Table In Storage Bucket Policy
Hey folks!
I'm experimenting with the storage bucket policies and have been trying to figure out how I can set up USING clause for a SELECT policy.
Here's some context:
1. I've created a custom
2. I have a private storage bucket called
3. However, I want SELECT to be allowed to the sentinel role, for which I tried doing this but it doesn't work:
4. I use an edge function with service role key to get the public URLs to the files and deliver to my app. I tried playing the videos using the URLs but the videos do not load.
If I return signed URLs, I can play videos owned by the authenticated user, not those of others.
What am I doing wrong?
I'm experimenting with the storage bucket policies and have been trying to figure out how I can set up USING clause for a SELECT policy.
Here's some context:
1. I've created a custom
usersrolesrole_id2. I have a private storage bucket called
liveness_checks3. However, I want SELECT to be allowed to the sentinel role, for which I tried doing this but it doesn't work:
4. I use an edge function with service role key to get the public URLs to the files and deliver to my app. I tried playing the videos using the URLs but the videos do not load.
If I return signed URLs, I can play videos owned by the authenticated user, not those of others.
What am I doing wrong?
