public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dominique Devienne <[email protected]>
To: [email protected]
Subject: Switching to NOINHERIT user triggers #XX000 error
Date: Tue, 5 Nov 2024 18:10:46 +0100
Message-ID: <CAFCRh-9byA_kmskbL5duYsjqZG3N78KuvY6TkiT3KuRo27=4QQ@mail.gmail.com> (raw)

Hi. Still working on porting our stuff to v16+, with the ROLE changes.

I'm facing a new issue. The same code and unit test works in v14,
when the LOGIN user running the test is INHERIT or NOINHERIT.

On v16 and v17 though, it works with INHERIT, but with NOINHERIT, I get:

GRANT "...:USER" TO "ddevienne" #XX000: ERROR:  no possible grantors

Any clue to what this means, so I can start looking in the right place?

In all 3 (or 6) cases, the code is the same, the client-side is
running libpq 17,
it's only the server that changes. The LOGIN user is the same, with the same
pg_roles attributes, with again the variable being INHERIT or not. --DD

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]
  Subject: Re: Switching to NOINHERIT user triggers #XX000 error
  In-Reply-To: <CAFCRh-9byA_kmskbL5duYsjqZG3N78KuvY6TkiT3KuRo27=4QQ@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