© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
51 replies
dhatGuy

Row level security; data returns null with join query

I have RLS on order and user table.
And I fetch the orders as a cafe owner using
const { data, error } = await supabaseClient
      .from("order")
      .select(`*, items:order_item(*), user(*)`);
const { data, error } = await supabaseClient
      .from("order")
      .select(`*, items:order_item(*), user(*)`);

The user property always return null but when I disable RLS on user table, I get the user data
unknown.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

row level security and react query
SupabaseSSupabase / help-and-questions
4y ago
Help with row level security
SupabaseSSupabase / help-and-questions
12mo ago
ROW LEVEL SECURITY ISSUE
SupabaseSSupabase / help-and-questions
3y ago
Row level security and data insert with react native
SupabaseSSupabase / help-and-questions
4y ago
Next page