© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
17 replies
Sloperrrr

Using ANY operator in RLS policy

Hi, new to Supabase and SQL so apologies but I'm stuck when trying to implement this policy on the
missions
missions
table. Summarized Allow if
user.authorized_missions
user.authorized_missions
(Array) contains
missions.id
missions.id


Here is my current policy:
any (user.authorized_missions) = missions.id
any (user.authorized_missions) = missions.id

but throwing "syntax error at or near 'any'". How can I fix this?
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
SupabaseSSupabase / help-and-questions
4mo ago
Restrictive RLS policy
SupabaseSSupabase / help-and-questions
2mo ago
RLS policy help
SupabaseSSupabase / help-and-questions
3y ago
RLS policy 'in' not working
SupabaseSSupabase / help-and-questions
4y ago