How can I set up an on insert RLS policy? Google h...
# helpv
Village
10/30/2021, 3:58 PMHow can I set up an on insert RLS policy? Google has returned me no examples of help, and my requests always error even if I set with check to just be true.
Village
10/30/2021, 4:01 PM Copy code
sql
CREATE POLICY "Allow users to insert their credentials"
ON public.credentials
AS PERMISSIVE
FOR insert
TO public
with check(true);h
HarryET
10/30/2021, 4:02 PMWas this made with the UI?
v
Village
10/30/2021, 4:02 PMBut the library then decides to say
"new row violates row-level security policy for table "credentials""Village
10/30/2021, 4:02 PMNo, I'm self-hosting
z
zeeshanok
10/30/2021, 4:03 PMdo u have a policy for
selectv
Village
10/30/2021, 4:03 PMI don't no
z
zeeshanok
10/30/2021, 4:03 PMyes so
zeeshanok
10/30/2021, 4:03 PMwhen u insert
zeeshanok
10/30/2021, 4:04 PMthe library also returns the new row u inserted
zeeshanok
10/30/2021, 4:04 PMwhich is a selct query
v
Village
10/30/2021, 4:04 PMAaah
z
zeeshanok
10/30/2021, 4:04 PMso u can either give selct a policy
zeeshanok
10/30/2021, 4:04 PMor u can set the return type of the query to be
minimalzeeshanok
10/30/2021, 4:04 PMone sec ill fetch the docs for thta
v
Village
10/30/2021, 4:04 PMOOOOOH
Village
10/30/2021, 4:05 PMIT WORKS NOW
z
zeeshanok
10/30/2021, 4:05 PMyes
zeeshanok
10/30/2021, 4:05 PMnice
zeeshanok
10/30/2021, 4:05 PMlol
v
Village
10/30/2021, 4:05 PMThank you!
Village
10/30/2021, 4:06 PMNow to get update to work so I can upsert
Village
10/30/2021, 4:37 PMDoes on conflict require to be able to select?
Village
10/30/2021, 4:37 PMIt seems that it does
Village
10/30/2021, 4:42 PMIt seems like it does