Re: multiple membership grants and information_schema.applicable_roles

From: Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>
To: 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-07-24 09:32:28
Message-ID: 1c156be6-5df1-03d7-adb0-a87754575e8d@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2023-07-24 09:56:24 Re: POC: GROUP BY optimization
Previous Message Dean Rasheed 2023-07-24 08:42:57 Re: cataloguing NOT NULL constraints