Re: struggling with GRANT while upgrading from 13 to 16

Поиск
Список
Период
Сортировка
От Steve Midgley
Тема Re: struggling with GRANT while upgrading from 13 to 16
Дата
Msg-id CAJexoSKVniyo9pkvZpwVEF13AaMzeqF_WA_NdK3YdjRWednPhg@mail.gmail.com
обсуждение исходный текст
Ответ на struggling with GRANT while upgrading from 13 to 16  (Axel Rau <Axel.Rau@Chaos1.DE>)
Ответы Re: struggling with GRANT while upgrading from 13 to 16
Список pgsql-sql
Дерево обсуждения


On Tue, Jun 25, 2024 at 10:05 AM Axel Rau <Axel.Rau@chaos1.de> wrote:
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 ?

Is there a reason you can't grant axel those other roles as admin? Such as:

GRANT daemons TO axel WITH ADMIN OPTION;
GRANT xtrole TO axel WITH ADMIN OPTION; 

I may be missing something really basic, but if you do that on v16 before running the load, would that fix it? Maybe there are security implications for your setup that make this unthinkable, but if that's true, having daemons and xtrole connected to these tables / data might be a problem more generally?

Steve

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