Am 21.11.24 um 21:42 schrieb Benjamin
Patrick:
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.tablenameI wanted to change the owner to the dbowner, but was unable in pgadmin or script. dbowner.schema.tablenameI 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.
Actually, PGAdmin problems should be discussed on the mailing list of PGAdmin.
But since the question isn't related to PGAdmin, but rather PostgreSQL server, I can give an answer here.
Some hints:
- Include the server version, at least the major version. Current is 17.1.
- Include the commands you have tried. Don't type them, copy
them!
- Include all messages you get from the server.
- If something doesn't work in PGAdmin, always try again using psql, because this is the only frontend maintained by the PostgreSQL developers.
It's not possible to change ownership of an object (table, view, schema, function, ...) to a role you aren't a member of. Otherwise, you might change it and lock yourself out.
And of course, you have to be owner of an object to alter it. Unless you are a superuser.
Kind Regards,
Holger
--
Holger Jakobs, Bergisch Gladbach
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature
