Why does db diff --linked show REVOKE statements after db reset, and why did applying them break my
I'm using Supabase CLI for local development. I encountered a confusing situation with database migrations and permissions that broke my app.
After running
In order to fix my app I did:
So... I am extremelly confused right now.
Why did
Is there a difference in how Supabase's local environment handles permissions vs remote? Does local apply some default security hardening that remote doesn't?
How do you guys deal with remote vs local Supabase development?
Thanks in advance.
After running
supabase db resetsupabase db diff --linkedIn order to fix my app I did:
grant usage on schema public to anon, authenticated, service_role;
grant all on all tables in schema public to anon, authenticated, service_role;
grant all on all routines in schema public to anon, authenticated, service_role;
grant all on all sequences in schema public to anon, authenticated, service_role;
alter default privileges for role postgres in schema public grant all on tables to anon, authenticated, service_role;
alter default privileges for role postgres in schema public grant all on routines to anon, authenticated, service_role;
alter default privileges for role postgres in schema public grant all on sequences to anon, authenticated, service_role;So... I am extremelly confused right now.
Why did
supabase db diff --linkedIs there a difference in how Supabase's local environment handles permissions vs remote? Does local apply some default security hardening that remote doesn't?
How do you guys deal with remote vs local Supabase development?
Thanks in advance.
