RLS policy set but message: "new row violates row-level security policy for table xxxxxx"
I attempt to insert a record via DB function using RPC. RLS is set on table and I send a access-token tied a authenticated user. got error.
I've built another DB function to ensure the user from access-token is really authentificated. I get
{
....
"aud": "authenticated",
"role": "authenticated",
...
}
Tried this RLS :
create policy "Enable users to handle their own data only"
on "public"."organisation"
to authenticated
using (
(( SELECT auth.uid() AS uid) = user_id)
);
Still get error.
Do you need more data ?
what sould I do ? ...something I've been mistaken with ?
I've built another DB function to ensure the user from access-token is really authentificated. I get
{
....
"aud": "authenticated",
"role": "authenticated",
...
}
Tried this RLS :
create policy "Enable users to handle their own data only"
on "public"."organisation"
to authenticated
using (
(( SELECT auth.uid() AS uid) = user_id)
);
Still get error.
Do you need more data ?
what sould I do ? ...something I've been mistaken with ?
