Re: struggling with GRANT while upgrading from 13 to 16

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Steve Midgley <[email protected]>
To: Axel Rau <[email protected]>
Cc: [email protected]
Subject: Re: struggling with GRANT while upgrading from 13 to 16
Date: Tue, 25 Jun 2024 10:28:11 -0700
Message-ID: <CAJexoSKVniyo9pkvZpwVEF13AaMzeqF_WA_NdK3YdjRWednPhg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Tue, Jun 25, 2024 at 10:05 AM Axel Rau <[email protected]> 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

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], [email protected]
  Subject: Re: struggling with GRANT while upgrading from 13 to 16
  In-Reply-To: <CAJexoSKVniyo9pkvZpwVEF13AaMzeqF_WA_NdK3YdjRWednPhg@mail.gmail.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