| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Benjamin Patrick <benjamin(dot)patrick(at)ilwllc(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Table owner change issue |
| Date: | 2024-11-21 22:12:20 |
| Message-ID: | bb0724fc00ad28dc73d9f8d985a37dd655f9d97c.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Motog Plus | 2024-11-22 02:54:56 | Re: Guidance Needed for PostgreSQL Upgrade from 12 to 15 |
| Previous Message | Holger Jakobs | 2024-11-21 20:54:18 | Re: Table owner change issue |