© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•6mo ago•
7 replies
Uchuu

I am losing my mind with this RLS policy

I have this policy so only premium users can access my DB.
  (((auth.jwt() -> 'app_metadata'::text) ->> 'is_premium'::text))::boolean
  (((auth.jwt() -> 'app_metadata'::text) ->> 'is_premium'::text))::boolean

But when I try to access it, I get no rows returned.

When I disable RLS, it works
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

How can i write this policy with [RLS]
SupabaseSSupabase / help-and-questions
3y ago
RLS Policy
SupabaseSSupabase / help-and-questions
4mo ago
RLS Policy With Join
SupabaseSSupabase / help-and-questions
4y ago
RLS Policy with array
SupabaseSSupabase / help-and-questions
4y ago