CLI Permission Error: Cannot Create Tables in Storage Schema During Local Reset
I'm hitting a weird permission issue with the Supabase CLI that seems like it shouldn't be happening.
What I'm trying to do:
The error:
Context:
- Local Supabase instance (Docker).
- This happens when the CLI tries to run my migration file that seems to create a table in the
- I initially got this error when running
- Even a fresh
- The migration file being ran was created after I updated my RLS policies to use
- After that, I made all my storage buckets public, and then removed all the RLS policies on them.
- Then tried running
I thought the Supabase CLI should have full superuser permissions on the local database?
Any help would be appreciated!
What I'm trying to do:
The error:
Context:
- Local Supabase instance (Docker).
- This happens when the CLI tries to run my migration file that seems to create a table in the
storage- I initially got this error when running
db pull --local --schema public,auth,storage- Even a fresh
db reset --local- The migration file being ran was created after I updated my RLS policies to use
(select auth.uid())auth.uid()db pull ...- After that, I made all my storage buckets public, and then removed all the RLS policies on them.
- Then tried running
db pull --local ...I thought the Supabase CLI should have full superuser permissions on the local database?
Any help would be appreciated!
