I have self hosted supabase, i have created my own schema and I have set RLS and added schema to api in confing.toml.
I can get data from python from my schema but nothing loading from flutterflow
only public schema is working
What should I do ?
Self hosted supabase how to get not public schema
Database & APIs
runned commands:
ALTER ROLE authenticator SET pgrst.db_schemas TO 'public, storage, graphql_public, myschema';
NOTIFY pgrst;
GRANT USAGE ON SCHEMA myschema TO anon, authenticated, service_role;
GRANT ALL ON ALL TABLES IN SCHEMA myschema TO anon, authenticated, service_role;
GRANT ALL ON ALL ROUTINES IN SCHEMA myschema TO anon, authenticated, service_role;
GRANT ALL ON ALL SEQUENCES IN SCHEMA myschema TO anon, authenticated, service_role;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA myschema GRANT ALL ON TABLES TO anon, authenticated, service_role;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA myschema GRANT ALL ON ROUTINES TO anon, authenticated, service_role;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA myschema GRANT ALL ON SEQUENCES TO anon, authenticated, service_role;
No
3