© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
Search
Star
Feedback
Setup for Free
S
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
Supabase
Join
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Similar Threads
Was this page helpful?
Yes
No
Recent Announcements
Similar Threads
RLS Policy syntax error at or near "create"
S
Supabase / help-and-questions
3y ago
RLS Policy giving ERROR413 on request
S
Supabase / help-and-questions
4y ago
TUS error: RLS policy
S
Supabase / help-and-questions
3y ago
RLS Policy
S
Supabase / help-and-questions
4mo ago