DROP POLICY IF EXISTS cable_plans_read_active ON public.cable_plans;
DROP POLICY IF EXISTS exam_products_read_active ON public.exam_products;

CREATE POLICY cable_plans_admin_read ON public.cable_plans
FOR SELECT TO authenticated
USING (public.has_role(auth.uid(), 'admin'::app_role));

CREATE POLICY exam_products_admin_read ON public.exam_products
FOR SELECT TO authenticated
USING (public.has_role(auth.uid(), 'admin'::app_role));

REVOKE SELECT ON public.cable_plans FROM anon;
REVOKE SELECT ON public.exam_products FROM anon;