RLS Policy Syntax Error

I'm trying to create a RLS policy that verifies the user's role from the public.roles table.
role is a postgres enumerated type consisting of parent, manager, and employee
Here is the schema for the roles table: https://img-ss.patrity.com/2023/12/chrome_gGO5s6Xv3a.png

Here is the policy: https://img-ss.patrity.com/2023/12/chrome_TAN757HIGO.png

There are no other policies in place and the only error text I receive in response is error near 'USING'

Any ideas or pointers is appreciated
Was this page helpful?