RLS Policy Syntax Error
I'm trying to create a RLS policy that verifies the user's role from the
Here is the schema for the
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
Any ideas or pointers is appreciated
public.roles table.role is a postgres enumerated type consisting of parent, manager, and employeeHere is the schema for the
roles table: https://img-ss.patrity.com/2023/12/chrome_gGO5s6Xv3a.pngHere 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

