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

2024-01-02 Thread Adrian Klaver
On 1/2/24 08:15, Dominique Devienne wrote: On Tue, Jan 2, 2024 at 5:09 PM Adrian Klaver > wrote: On 1/2/24 07:24, Dominique Devienne wrote: > pg_has_role() from > https://www.postgresql.org/docs/current/functions-info.html

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

2024-01-02 Thread Adrian Klaver
On 1/2/24 08:21, Dominique Devienne wrote: On Tue, Jan 2, 2024 at 5:11 PM David G. Johnston mailto:david.g.johns...@gmail.com>> wrote: On Tue, Jan 2, 2024 at 8:25 AM Dominique Devienne mailto:ddevie...@gmail.com>> wrote: pg_has_role() from https://www.postgresql.org/doc

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

2024-01-02 Thread David G. Johnston
On Tue, Jan 2, 2024 at 9:21 AM Dominique Devienne wrote: > On Tue, Jan 2, 2024 at 5:11 PM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Tue, Jan 2, 2024 at 8:25 AM Dominique Devienne >> wrote: >> >>> pg_has_role() from >>> https://www.postgresql.org/docs/current/functions-info

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

2024-01-02 Thread Dominique Devienne
On Tue, Jan 2, 2024 at 5:11 PM David G. Johnston wrote: > On Tue, Jan 2, 2024 at 8:25 AM Dominique Devienne > wrote: > >> pg_has_role() from >> 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

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

2024-01-02 Thread Dominique Devienne
On Tue, Jan 2, 2024 at 5:09 PM Adrian Klaver wrote: > On 1/2/24 07:24, Dominique Devienne wrote: > > pg_has_role() from > > https://www.postgresql.org/docs/current/functions-info.html > > > > added the 'SET' privilege in v16, and on to

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

2024-01-02 Thread David G. Johnston
On Tue, Jan 2, 2024 at 8:25 AM Dominique Devienne wrote: > Hi. And happy new year (for those using the Gregorian calendar). > > pg_has_role() from > https://www.postgresql.org/docs/current/functions-info.html > added the 'SET' privilege in v16, and on top of the existing 'MEMBER' and > 'USAGE' on

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

2024-01-02 Thread Adrian Klaver
On 1/2/24 07:24, Dominique Devienne wrote: Hi. And happy new year (for those using the Gregorian calendar). pg_has_role() from https://www.postgresql.org/docs/current/functions-info.html added the 'SET' privilege in v16, and on top

New SET privilege for pg_has_role() in v16+

2024-01-02 Thread Dominique Devienne
Hi. And happy new year (for those using the Gregorian calendar). pg_has_role() from 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: > MEMBER denotes direct or indirect membership in the role [...]