I’m unable to drop tables in the SQL editor getting the following error: “ERROR: must be owner of table users (SQLSTATE 42501)”
I think this is because I created a new user to be used for my migrations, gave ownership of the database to this new user so that it can change the schema, and then created the tables through this user.
Is it possible to give the web_access user (From reading other posts this is what the SQL editor uses?) more grants so that I can drop tables with it that are created by other users? Or alternatively if the default user created with my account can do this, is there a way to use this default user through the SQL editor?