I am using PGAdmin 4.8.8. New to the group and hoping this the correct group for assistance.
My instance is an AWS instance so there isn't a viable superuser.
I had a user create table with the table owner being themself. user.schema.tablename
I wanted to change the owner to the dbowner, but was unable in pgadmin or script. dbowner.schema.tablename
I had the user run a script to the change the table owner to the dbowner but the user received an error unable to set role. This occurred both in script and pgadmin.
The table owner was able to change to a mutual role that both the user and the dbowner are members. From there the dbowner was still unable to change the table owner to the dbowner.
Any assistance would be super helpful.
