1

Whenever I try to modify an existing table in the Supabase dashboard, I get this error "Failed to pg.columns: must be owner of table <table_name>". This seems to be like a permission issue but I'm not sure what has to be done to fix this.

I have also tried to run the SQL script to ALTER the table, but I still get the same error saying I must be the owner of the table.

Failed to run sql query: must be owner of table online_users

This project is hosted on Supabase cloud and I'm not self-hosting this project. Also, I have disabled RLS for the table which I'm trying to modify.

I have tried granting permissions using these commands that I found on other similar permission issues for Supabase. But even these commands return the following errors -

GRANT supabase_admin TO postgres;

"Failed to run sql query: must be superuser to alter superusers"

ALTER USER postgres WITH superuser;

"Failed to run sql query: must be superuser to alter superuser roles or change superuser attribute"

Any help is appreciated! Thanks.

Prateik
  • 33
  • 5
  • 1
    Hi there, roughly when was this project created? If you don't mind, would you be able to reach out to support to get this one sorted out? https://app.supabase.com/support/new – dshukertjr May 08 '23 at 05:08

2 Answers2

1

Same, i posted this in the reddit group yesterday and they said to log a ticket with Supabase.

The only way i was able to solve it in a timely manner (I'm on the free tier) was to create a new workspace and recreate the table. Luckily i had backups of the data. I looked through all the settings and nothing's different from my end as far as i can see. So i'm guessing Supabase did something to mess this up for everyone.

Don Giovanni
  • 11
  • 2
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community May 10 '23 at 07:48
0

I eventually contacted the support, and they asked me to execute a couple of scripts in my dashboard. The scripts they provided kept failing, and after a couple of days, they fixed it from their end. Now the issue is resolved.

P.S. Their support was pretty good and they always got back to me within a day.

Prateik
  • 33
  • 5