Re: multiple membership grants and information_schema.applicable_roles

On 24.07.2023 09:42, Pavel Luzanov wrote:
> Is IS_GRANTABLE a key column for ROLE_AUTHORIZATION_DESCRIPTORS?
> If not, duplicates is not possible. Right?

The answer is: no.
Duplicate pairs (grantee, role_name) is impossible only with defined key 
with this two columns.
If there is no such key or key contain another column, for example grantor,
then the information_schema.applicable_roles view definition is correct 
in this part.

-- 
Pavel Luzanov
Postgres Professional: https://postgrespro.com