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 gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.