403 RLS error (banging my head)
Hi all, I'm relatively new to the supabase world and PostgreSQL. I have a project with multiple tables in it. I've created RLS policies for the table that says allow authenticated user to insert a row like this:
create policy "Allow authenticated users to insert their own signature grants"
on "data"."signaturegrant"
to authenticated
with check (
(user_id = auth.uid())
);
I read through other posts but still just stuck. I can't query the table even in the builtin SQL editor on the web interface. Getting this: ERROR: 42501: permission denied for table signaturegrant
If I run the same command as the postgres user it works fine (obviously)...so I know it's a permissions issue, and maybe not even an RLS issue? I'm certain I just missed something. If anyone could point me in the right direction I would GREATLY appreciate it!
create policy "Allow authenticated users to insert their own signature grants"
on "data"."signaturegrant"
to authenticated
with check (
(user_id = auth.uid())
);
I read through other posts but still just stuck. I can't query the table even in the builtin SQL editor on the web interface. Getting this: ERROR: 42501: permission denied for table signaturegrant
If I run the same command as the postgres user it works fine (obviously)...so I know it's a permissions issue, and maybe not even an RLS issue? I'm certain I just missed something. If anyone could point me in the right direction I would GREATLY appreciate it!
