Simple RLS Policy with Join

I would think this would work:

(role() = 'authenticated'::text) AND (authorId.id = uuid())

(role() = 'authenticated'::text) AND (authorId.id = uuid())

Here

authorId

authorId

is a FK to

profiles.id

profiles.id

. I simply want to make sure a user can't insert a post where the author is someone else.

I get column "authorId" does not exist when trying to create the policy, but it does exist. It is an fk field.

J

Simple RLS Policy with Join

Similar Threads

Simple RLS Policy with Join

Similar Threads

Similar Threads

Similar Threads