© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3mo ago•
10 replies
Cobalt

Issue with SELECT Policy

This is my first time using Supabase and I am trying to make a policy that allows a user to view portfolios uploaded by his team. First, it checks the user's email using auth.jwt(), then finds the team number of the user in another table before returning all the rows that have that team number attached with them. However, for some reason, it seems to fail silently and doesn't give me any data. Some help would be appreciated.
image.png
image.png
image.png
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

Select not returning any rows after enabling RLS with authenticated policy
SupabaseSSupabase / help-and-questions
4y ago
Help with policy condition
SupabaseSSupabase / help-and-questions
14mo ago
RLS Policy With Join
SupabaseSSupabase / help-and-questions
4y ago
RLS Policy with array
SupabaseSSupabase / help-and-questions
4y ago