So I want to let all logged users insert into myTable, I would think the following would work, but I get RLS error.

CREATE POLICY "logged in users can insert into myTable"
    ON public.myTable FOR INSERT to authenticated
    with check (
      true
    );

Error new row violates row-level security policy for table "myTable Postgres Username authenticator Also is there an easy overview of all the different roles/ postgres usernames used, when they are used and for what? I fail too find one, would be nice with a cheatsheet.

If you have select at end of insert you also need select policy. The only two roles that matter are authenticated and anon. If you put anon where authenticated is and it works then you are not really signed in which is a good thing to check because that happens to people alot.

I have tested with just anon and it failed, but somehow it also failed with this. so perhaps its my check

CREATE POLICY "logged in users can insert into myTable"
    ON public.myTable FOR INSERT
    with check (
      true
    );

myTable will not work. You really should not use capital letters. You need public."myTable"

yeh sorry about that, the table is not named myTable, and I use snake case.

Ah

yes, but the user is able to see previosly created rows in an overview page, so I think my select policy is working fine.

by default views bypass RLS

yeh, my select policy is flawed

if you do .insert.select() you need select.

Sorry for the poor formatting

ts
const { data, error } = await supabase.from('my_table').insert({    start_at: start,        end_at: end
});

should not be unless you are on ..... V1 of supabase-js