© 2026 Hedgehog Software, LLC

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

Query data in public schema from private schema

All of my tables are in a private schema. I am writing functions in the public schema to pull data from the private schema. When I test the API with CURL this is the message I am receiving.
{"message":"permission denied for schema private","code":"42501","details":null,"hint":null}%
{"message":"permission denied for schema private","code":"42501","details":null,"hint":null}%
What is the best approach for opening up security on these functions? Do I need to setup RLS on the tables in the private schema?
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

write on public schema fails
SupabaseSSupabase / help-and-questions
3y ago
custom private schemas
SupabaseSSupabase / help-and-questions
6mo ago
PGRST202 error with queues: public.pgmq_public.send not found in schema cache
SupabaseSSupabase / help-and-questions
13mo ago
Query data in jsonb values array
SupabaseSSupabase / help-and-questions
4y ago