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.