viktor
05/26/2023, 1:12 PMCREATE 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.garyaustin
05/26/2023, 1:18 PMviktor
05/26/2023, 1:37 PMCREATE POLICY "logged in users can insert into myTable"
ON public.myTable FOR INSERT
with check (
true
);
garyaustin
05/26/2023, 1:39 PMgaryaustin
05/26/2023, 1:40 PMviktor
05/26/2023, 1:41 PMviktor
05/26/2023, 1:41 PMgaryaustin
05/26/2023, 1:41 PMgaryaustin
05/26/2023, 1:42 PMviktor
05/26/2023, 1:43 PMviktor
05/26/2023, 1:43 PMviktor
05/26/2023, 1:44 PMgaryaustin
05/26/2023, 1:44 PMviktor
05/26/2023, 1:46 PMviktor
05/26/2023, 1:46 PMviktor
05/26/2023, 1:47 PMgaryaustin
05/26/2023, 1:48 PMgaryaustin
05/26/2023, 1:48 PMhttps://cdn.discordapp.com/attachments/1111643077917028352/1111652191946670170/image.png▾
viktor
05/26/2023, 1:50 PMts
const { data, error } = await supabase.from('my_table').insert({ start_at: start, end_at: end
});
viktor
05/26/2023, 1:51 PMviktor
05/26/2023, 1:52 PMviktor
05/26/2023, 1:55 PMgaryaustin
05/26/2023, 1:58 PM