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: [email protected]
Views: Whole Thread | Raw Message | 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