30 lines
1.7 KiB
SQL
30 lines
1.7 KiB
SQL
-- Enable Row Level Security on all public tables.
|
|
-- Our app accesses Supabase exclusively via Prisma with the service_role key,
|
|
-- which bypasses RLS automatically. No permissive policies are needed.
|
|
-- This prevents direct PostgREST API access to table data.
|
|
|
|
ALTER TABLE public."Owner" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Pet" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Post" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."VideoPost" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."PostImage" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."PostHashtag" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Hashtag" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Comment" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Reaction" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Repost" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Follow" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Report" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Notification" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Message" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Conversation" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."HealthCard" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."EmergencyVet" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."VetVisit" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Vaccine" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."WeightLog" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."Advertisement" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."ModerationLog" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."AdminRole" ENABLE ROW LEVEL SECURITY;
|
|
ALTER TABLE public."UserBan" ENABLE ROW LEVEL SECURITY;
|