struggling with GRANT while upgrading from 13 to 16

Поиск
Список
Период
Сортировка
От Axel Rau
Тема struggling with GRANT while upgrading from 13 to 16
Дата
Msg-id A9A63660-310A-4F87-B01D-998E3A3A086A@Chaos1.DE
обсуждение исходный текст
Ответы Re: struggling with GRANT while upgrading from 13 to 16
Re: struggling with GRANT while upgrading from 13 to 16
Список 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




В списке pgsql-sql по дате отправления: