fix_rls_issues.sql

-- Fix RLS policy errors for fresh users

-- ================================
-- CLIENTS TABLE RLS POLICIES
-- ================================

-- Drop existing policies
DROP POLICY IF EXISTS "Users can view their own clients" ON clients;
DROP POLICY IF EXISTS "Users can insert their own clients" ON clients;
DROP POLICY IF EXISTS "Users can update their own clients" ON clients;
DROP POLICY IF EXISTS "Users can delete their own clients" ON clients;

-- Create more permissive policies for fresh users
CREATE POLICY "Users can view all clients" 
ON clients FOR SELECT 
TO authenticated 
USING (true);

CREATE POLICY "Users can insert clients" 
ON clients FOR INSERT 
TO authenticated 
WITH CHECK (true);

CREATE POLICY "Users can update clients" 
ON clients FOR UPDATE 
TO authenticated 
USING (true);

CREATE POLICY "Users can delete clients" 
ON clients FOR DELETE 
TO authenticated 
USING (true);

-- ================================
-- FINANCIAL_PLANS TABLE RLS POLICIES
-- ================================

-- Drop existing policies
DROP POLICY IF EXISTS "Users can view their own financial plans" ON financial_plans;
DROP POLICY IF EXISTS "Users can insert their own financial plans" ON financial_plans;
DROP POLICY IF EXISTS "Users can update their own financial plans" ON financial_plans;
DROP POLICY IF EXISTS "Users can delete financial plans for clients they can access" ON financial_plans;

-- Create more permissive policies for fresh users
CREATE POLICY "Users can view all financial plans" 
ON financial_plans FOR SELECT 
TO authenticated 
USING (true);

CREATE POLICY "Users can insert financial plans" 
ON financial_plans FOR INSERT 
TO authenticated 
WITH CHECK (true);

CREATE POLICY "Users can update financial plans" 
ON financial_plans FOR UPDATE 
TO authenticated 
USING (true);

CREATE POLICY "Users can delete financial plans" 
ON financial_plans FOR DELETE 
TO authenticated 
USING (true);