© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
8 replies
bummzack

Getting error when pushing local migrations to supabase.

I've created a local migration that works just fine locally, but whenever I try to push it to the remote DB, I get:

Error: ERROR: must be member of role "authenticated" (SQLSTATE 42501)
Error: ERROR: must be member of role "authenticated" (SQLSTATE 42501)


I'm creating a
view
view
that should have
authenticated
authenticated
as owner, since I need RLS to apply to the view. The statement that generates the error is:

alter view public.my_view owner to authenticated;
alter view public.my_view owner to authenticated;


Is there a workaround for this?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Need help with pushing local changes to supabase remote
SupabaseSSupabase / help-and-questions
8mo ago
Local Supabase OAuth Error
SupabaseSSupabase / help-and-questions
3y ago
Baselining Migrations -- Local
SupabaseSSupabase / help-and-questions
5mo ago
Cannot `supabase db push` after adding local migrations
SupabaseSSupabase / help-and-questions
4y ago