RLS Policy Generator

-- RLS Policy Generator
-- Table: posts

CREATE TABLE posts (
  id uuid,
  title text,
  content text,
  user_id uuid,
  created_at timestamptz
);

-- Enable Row Level Security
ALTER TABLE posts ENABLE ROW LEVEL SECURITY;

-- anon can SELECT
CREATE POLICY "anon_select_posts" ON posts
  FOR SELECT TO anon
  USING (true);

-- authenticated can SELECT
CREATE POLICY "authenticated_select_posts" ON posts
  FOR SELECT TO authenticated
  USING (true);

-- owner can SELECT their own rows
CREATE POLICY "owner_select_posts" ON posts
  FOR SELECT TO authenticated
  USING (auth.uid() = user_id);

-- owner can INSERT their own rows
CREATE POLICY "owner_insert_posts" ON posts
  FOR INSERT TO authenticated
  WITH CHECK (auth.uid() = user_id);

-- owner can UPDATE their own rows
CREATE POLICY "owner_update_posts" ON posts
  FOR UPDATE TO authenticated
  USING (auth.uid() = user_id)
  WITH CHECK (auth.uid() = user_id);

-- owner can DELETE their own rows
CREATE POLICY "owner_delete_posts" ON posts
  FOR DELETE TO authenticated
  USING (auth.uid() = user_id);