iloom-flatten/migrations/20260523_162407_drop_old_rls_policies.sql

41 lines
2.4 KiB
MySQL
Raw Permalink Normal View History

-- ============================================
-- 此文件由 Meoo Cloud 自动生成,请勿修改
-- This file is auto-generated by Meoo Cloud, DO NOT MODIFY
-- ============================================
-- 删除现有宽松的 RLS 策略
DROP POLICY IF EXISTS anon_select_companies ON public.companies;
DROP POLICY IF EXISTS anon_insert_companies ON public.companies;
DROP POLICY IF EXISTS anon_update_companies ON public.companies;
DROP POLICY IF EXISTS anon_select_profiles ON public.profiles;
DROP POLICY IF EXISTS anon_insert_profiles ON public.profiles;
DROP POLICY IF EXISTS users_update_own_profile ON public.profiles;
DROP POLICY IF EXISTS anon_select_company_members ON public.company_members;
DROP POLICY IF EXISTS anon_insert_company_members ON public.company_members;
DROP POLICY IF EXISTS anon_select_plans ON public.production_plans;
DROP POLICY IF EXISTS anon_insert_plans ON public.production_plans;
DROP POLICY IF EXISTS anon_update_plans ON public.production_plans;
DROP POLICY IF EXISTS anon_delete_plans ON public.production_plans;
DROP POLICY IF EXISTS anon_select_plan_factories ON public.plan_factories;
DROP POLICY IF EXISTS anon_insert_plan_factories ON public.plan_factories;
DROP POLICY IF EXISTS anon_delete_plan_factories ON public.plan_factories;
DROP POLICY IF EXISTS anon_select_yarn_ratios ON public.yarn_ratios;
DROP POLICY IF EXISTS anon_insert_yarn_ratios ON public.yarn_ratios;
DROP POLICY IF EXISTS anon_delete_yarn_ratios ON public.yarn_ratios;
DROP POLICY IF EXISTS anon_select_warehouses ON public.warehouses;
DROP POLICY IF EXISTS anon_insert_warehouses ON public.warehouses;
DROP POLICY IF EXISTS anon_update_warehouses ON public.warehouses;
DROP POLICY IF EXISTS anon_select_inventory ON public.inventory_records;
DROP POLICY IF EXISTS anon_insert_inventory ON public.inventory_records;
DROP POLICY IF EXISTS anon_select_yarn_stock ON public.yarn_stock;
DROP POLICY IF EXISTS anon_insert_yarn_stock ON public.yarn_stock;
DROP POLICY IF EXISTS anon_update_yarn_stock ON public.yarn_stock;
DROP POLICY IF EXISTS anon_select_process_steps ON public.plan_process_steps;
DROP POLICY IF EXISTS anon_insert_process_steps ON public.plan_process_steps;
DROP POLICY IF EXISTS anon_update_process_steps ON public.plan_process_steps;
DROP POLICY IF EXISTS anon_select_payments ON public.payments;
DROP POLICY IF EXISTS anon_insert_payments ON public.payments;
DROP POLICY IF EXISTS anon_update_payments ON public.payments;