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
