supabase_rls_setup.sql

-- 1. Enable Row Level Security
ALTER TABLE public.users ENABLE ROW LEVEL SECURITY;

-- 2. Create Policy for Inserting Data
-- This allows authenticated users to insert a row, but ONLY if the id matches their auth.uid()
CREATE POLICY "Users can insert their own profile"
ON public.users FOR INSERT
WITH CHECK (auth.uid() = id);

-- 3. Create Policy for Updating Data
-- This allows authenticated users to update their own row
CREATE POLICY "Users can update their own profile"
ON public.users FOR UPDATE
USING (auth.uid() = id);

-- 4. Create Policy for Viewing Data
-- This allows authenticated users to view their own profile
CREATE POLICY "Users can view their own profile"
ON public.users FOR SELECT
USING (auth.uid() = id);

-- 5. (Optional) Allow public read access to avatars/names if needed
-- CREATE POLICY "Public profiles are viewable"
-- ON public.users FOR SELECT
-- USING (true);