which seems odd for the obvious reason, so I tried the obvious thing: GRANTSELECT, INSERT,UPDATEONALL TABLESINSCHEMA"public"TO supabase_auth_admin which executed fine but seems to have done nothing to help. Prior to this, I deleted all the users from the dashboard. It's okay to do tha...
When I use signInAnonymously() the client gets a valid JWT with the authenticated role but all calls to the database fail with permission denied for schema public To Reproduce await supabase.auth.signInAnonymously() await supabase.from("table_name").insert(data) Expected behavior Anonymously ...
L-Mario564 added drizzle/studio driver/supabase labels Nov 28, 2024 limegorilla commented Nov 29, 2024 Can confirm I also get this. Have also tried to create a custom config for studio alone, which specifically ignores the table/schema schema_migrations is in, but no luckSign...
The SQL that @sweatybridge posted did not work, permissions denied. However, the following ran successfully and allowed me to run npx supabase db dump -f supabase/data.sql --data-only successfully. GRANT ALL ON ALL TABLES IN SCHEMA supabase_functions TO postgres; GRANT ALL ON ALL SEQUENCES ...