public inbox for [email protected]  

help / color / mirror / Atom feed

From: Benjamin Patrick <[email protected]>
To: [email protected] <[email protected]>
Subject: Table owner change issue
Date: Thu, 21 Nov 2024 20:42:23 +0000
Message-ID: <MN2PR18MB346262E20C3F101F7C1A8324F4222@MN2PR18MB3462.namprd18.prod.outlook.com> (raw)

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.

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Table owner change issue
  In-Reply-To: <MN2PR18MB346262E20C3F101F7C1A8324F4222@MN2PR18MB3462.namprd18.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox