| From: | Axel Rau <Axel(dot)Rau(at)Chaos1(dot)DE> |
|---|---|
| To: | pgsql-sql(at)lists(dot)postgresql(dot)org |
| Subject: | struggling with GRANT while upgrading from 13 to 16 |
| Date: | 2024-06-25 17:04:41 |
| Message-ID: | A9A63660-310A-4F87-B01D-998E3A3A086A@Chaos1.DE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi all,
I’m getting
ERROR: permission denied to grant privileges as role "axel"
DETAIL: The grantor must have the ADMIN option on role "daemons".
ERROR: permission denied to grant privileges as role "axel"
DETAIL: The grantor must have the ADMIN option on role "daemons".
ERROR: permission denied to grant privileges as role "axel"
DETAIL: The grantor must have the ADMIN option on role "xtrole".
ERROR: permission denied to grant privileges as role "axel"
DETAIL: The grantor must have the ADMIN option on role "xtrole".
while trying load a dump from 13 into 16 server.
Correcting this on 13 seems impossible as new syntax/options are required.
What would be the upgrade path to fix this?
What would be the SQL phrase to do it ?
Any help appreciated,
Axel
---
PGP-Key: CDE74120 ☀ mobile: +49 160 7568212
computing @ chaos claudius
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Midgley | 2024-06-25 17:28:11 | Re: struggling with GRANT while upgrading from 13 to 16 |
| Previous Message | Kanimozhi Manoharan | 2024-06-03 05:26:07 | Re: Postgres fine tuning |