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.