Re: multiple membership grants and information_schema.applicable_roles

[Peter Eisentraut]

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.