Re: Table owner change issue

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Table owner change issue
Date: 2024-11-21 20:54:18
Message-ID: 3b9b5142-e80d-e306-4ba0-8a5361a97775@jakobs.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.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.
>
>
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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-11-21 22:12:20 Re: Table owner change issue
Previous Message Benjamin Patrick 2024-11-21 20:42:23 Table owner change issue