Re: New SET privilege for pg_has_role() in v16+

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: New SET privilege for pg_has_role() in v16+
Date: 2024-01-02 16:15:46
Message-ID: CAFCRh-9agYGrmhEcdb4guZU78SmoiTXek+WaCrk1ujMngaKNNQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 2, 2024 at 5:09 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 1/2/24 07:24, Dominique Devienne wrote:
> > pg_has_role() from
> > https://www.postgresql.org/docs/current/functions-info.html
> > <https://www.postgresql.org/docs/current/functions-info.html>
> > added the 'SET' privilege in v16, and on top of the existing 'MEMBER'
> > and 'USAGE' ones:
>
> https://www.postgresql.org/docs/current/sql-set-role.html
>
> "[...], if the role was granted WITH SET TRUE [...]"
>

That seems to be the important part of your RFTM answer, which is
apparently new in v16.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2024-01-02 16:21:32 Re: New SET privilege for pg_has_role() in v16+
Previous Message David G. Johnston 2024-01-02 16:11:12 Re: New SET privilege for pg_has_role() in v16+