© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3y ago•
10 replies
Patrity

RLS Policy Syntax Error

I'm trying to create a RLS policy that verifies the user's role from the
public.roles
public.roles
table.
role
role
is a postgres enumerated type consisting of
parent
parent
,
manager
manager
, and
employee
employee

Here is the schema for the
roles
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'
error near 'USING'


Any ideas or pointers is appreciated
Preview image
Preview image
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

RLS Policy syntax error at or near "create"
SupabaseSSupabase / help-and-questions
3y ago
RLS Policy giving ERROR413 on request
SupabaseSSupabase / help-and-questions
4y ago
TUS error: RLS policy
SupabaseSSupabase / help-and-questions
3y ago
RLS Policy
SupabaseSSupabase / help-and-questions
4mo ago