eMeRiKa
01/04/2022, 2:15 PMberu
01/04/2022, 2:31 PMberu
01/04/2022, 2:31 PMeMeRiKa
01/04/2022, 2:32 PMeMeRiKa
01/04/2022, 2:33 PMberu
01/04/2022, 2:38 PMeMeRiKa
01/04/2022, 2:38 PMberu
01/04/2022, 2:38 PMeMeRiKa
01/04/2022, 2:38 PMberu
01/04/2022, 2:39 PMberu
01/04/2022, 2:39 PMeMeRiKa
01/04/2022, 2:40 PMberu
01/04/2022, 2:41 PMberu
01/04/2022, 2:42 PMmove
& update
is the same, so it should probably work for move
eMeRiKa
01/04/2022, 2:44 PMeMeRiKa
01/04/2022, 2:45 PMberu
01/04/2022, 2:49 PMberu
01/04/2022, 2:49 PMeMeRiKa
01/04/2022, 2:50 PMeMeRiKa
01/04/2022, 2:50 PMeMeRiKa
01/04/2022, 2:51 PMberu
01/04/2022, 2:52 PMsql
CREATE POLICY "policy_name"
ON storage.objects
FOR UPDATE USING (
auth.role() = 'authenticated'
) WITH CHECK (
auth.role() = 'authenticated'
);
eMeRiKa
01/04/2022, 2:52 PMberu
01/04/2022, 2:52 PMeMeRiKa
01/04/2022, 3:05 PMberu
01/04/2022, 3:08 PMberu
01/06/2022, 1:52 PMsql
create policy "give select access to folder for authenticated users"
on storage.objects for select using (
bucket_id = 'bucket'
and (storage.foldername(name))[1] = 'folder'
and auth.role() = 'authenticated'
);
create policy "give update access to folder for authenticated users"
on storage.objects for update using (
bucket_id = 'bucket'
and (storage.foldername(name))[1] = 'folder'
and auth.role() = 'authenticated'
);
eMeRiKa
01/06/2022, 2:21 PM