Thread: Table owner change issue

Table owner change issue

From
Benjamin Patrick
Date:
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.


 

Re: Table owner change issue

From
Laurenz Albe
Date:
On Thu, 2024-11-21 at 20:42 +0000, Benjamin Patrick wrote:
> 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

See the documentation: https://www.postgresql.org/docs/current/sql-altertable.html

  "To alter the owner, you must be able to SET ROLE to the new owning role,
  and that role must have CREATE privilege on the table's schema."

Yours,
Laurenz Albe