Re: multiple membership grants and information_schema.applicable_roles

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
Subject: Re: multiple membership grants and information_schema.applicable_roles
Date: 2023-08-02 09:32:43
Message-ID: e03da7d9-7f2e-2f0c-424e-1c36ac520a7a@eisentraut.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 24.07.23 08:42, Pavel Luzanov wrote:
>> I do see what seems like a different issue: the standard appears to
>> expect
>> that indirect role grants should also be shown (via the recursive CTE),
>> and we are not doing that.
>
> I noticed this, but the view stays unchanged so long time.
> I thought it was done intentionally.

The implementation of the information_schema.applicable_roles view
predates both indirect role grants and recursive query support. So some
updates might be in order.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiro Ikeda 2023-08-02 09:34:15 Re: Support to define custom wait events for extensions
Previous Message Amit Kapila 2023-08-02 09:26:06 Re: Adding a LogicalRepWorker type field