1 BHK Flat For Sale

Description

-- ===================================================== -- SECTION 8: STORAGE POLICIES -- ===================================================== -- Ensure the storage bucket exists (usually done via dashboard) INSERT INTO storage.buckets (id, name, public) VALUES ('property-images', 'property-images', true) ON CONFLICT (id) DO NOTHING; -- Policy 1: Public Read Access -- Allow anyone to view images in the 'property-images' bucket CREATE POLICY "Public Access" ON storage.objects FOR SELECT USING (bucket_id = 'property-images'); -- Policy 2: Admin Upload Access -- Only admins can upload images to 'property-images' bucket CREATE POLICY "Admins can upload property images" ON storage.objects FOR INSERT TO authenticated WITH CHECK ( bucket_id = 'property-images' AND EXISTS (SELECT 1 FROM profiles WHERE id = auth.uid() AND is_admin = TRUE) ); -- Policy 3: Admin Update Access -- Only admins can update images CREATE POLICY "Admins can update property images" ON storage.objects FOR UPDATE TO authenticated USING ( bucket_id = 'property-images' AND EXISTS (SELECT 1 FROM profiles WHERE id = auth.uid() AND is_admin = TRUE) ); -- Policy 4: Admin Delete Access -- Only admins can delete images CREATE POLICY "Admins can delete property images" ON storage.objects FOR DELETE TO authenticated USING ( bucket_id = 'property-images' AND EXISTS (SELECT 1 FROM profiles WHERE id = auth.uid() AND is_admin = TRUE) );

Amenities

Location