Message-ID: <bb0724fc00ad28dc73d9f8d985a37dd655f9d97c.camel@cybertec.at>
Subject: Re: Table owner change issue
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Benjamin Patrick <benjamin.patrick@ilwllc.com>,
 "pgsql-admin@lists.postgresql.org"
	 <pgsql-admin@lists.postgresql.org>
Date: Thu, 21 Nov 2024 23:12:20 +0100
In-Reply-To: 
 <MN2PR18MB346262E20C3F101F7C1A8324F4222@MN2PR18MB3462.namprd18.prod.outlook.com>
References: 
	<MN2PR18MB346262E20C3F101F7C1A8324F4222@MN2PR18MB3462.namprd18.prod.outlook.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-2.fc40) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/bb0724fc00ad28dc73d9f8d985a37dd655f9d97c.camel%40cybertec.at>
Precedence: bulk

On Thu, 2024-11-21 at 20:42 +0000, Benjamin Patrick wrote:
> I am using PGAdmin 4.8.8.=C2=A0 New to the group and hoping this the corr=
ect 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.=C2=A0 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-altertab=
le.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