© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3y ago•
22 replies
Ryann

Must be owner of table 'contacts', Just to change setting.

I'm not sure why I'm having this issue now rather then before, only since SB added the role selector it seems in sql editor.

I simply want to change the table 'contacts'=>user_id to be nullable true.

Table owner is 'supabase_admin', my current user is 'postgres'. Even editing table setting in the GUI gives me the error.

Like why is this happening now and never before, and how would I act as the owner? I cant change the owner of the table without being the owner of the table.
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

must be owner of table
SupabaseSSupabase / help-and-questions
4mo ago
ERROR: must be owner of table objects
SupabaseSSupabase / help-and-questions
8mo ago
ERROR: must be owner of table "name"
SupabaseSSupabase / help-and-questions
3y ago
ERROR: 42501: must be owner of table objects
SupabaseSSupabase / help-and-questions
3mo ago