Team

RLS-backed access control. Team members are stored in marketing.team_members.

Seeded users
From migration 005
Role guide
  • super_admin

    Full read + write across all marketing tables; can manage team_members.

  • admin

    Full read; can manage campaigns but not team_members.

  • editor

    Read + create posts/campaigns; cannot delete or manage team.

  • viewer

    Read-only access to aggregated rollups.

Adding a teammate
SQL migration + supabase auth invite
  1. Invite via Auth → Users.
  2. INSERT INTO marketing.team_members (user_id, role)
VALUES ('<auth.users.id>', 'editor')
ON CONFLICT (user_id) DO NOTHING;
  3. RLS picks up the new role on next request.
Configuration
Runtime state
Supabase URL
https://hupiguhcsmeucownlbre.supabase.co
Anon key
configured
Service role key
missing