alter table public.projects enable row level security;

drop policy if exists estimator_authenticated_read on public.projects;
drop policy if exists estimator_authenticated_insert on public.projects;
drop policy if exists estimator_authenticated_update on public.projects;
drop policy if exists estimator_authenticated_delete on public.projects;

create policy estimator_authenticated_read
on public.projects for select
to authenticated
using (true);

create policy estimator_authenticated_insert
on public.projects for insert
to authenticated
with check (true);

create policy estimator_authenticated_update
on public.projects for update
to authenticated
using (true)
with check (true);

create policy estimator_authenticated_delete
on public.projects for delete
to authenticated
using (true);

1. Open your Supabase project.
2. Go to Authentication → Users.
3. Click Add user or Invite user.
4. Use the estimator's company email address and a temporary password.
5. To remove access, delete or disable that Supabase Auth user.