Re: Why is_admin_of_role() use ROLERECURSE_MEMBERS rather thanROLERECURSE_PRIVS?

From: preTham <prezza672(at)gmail(dot)com>
To: cca5507 <cca5507(at)qq(dot)com>
Cc: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Why is_admin_of_role() use ROLERECURSE_MEMBERS rather thanROLERECURSE_PRIVS?
Date: 2025-12-24 07:05:31
Message-ID: CAJUn_kMBrU==ajPWz+3tw6YtxfCQryXZePdANcL+OJFSM0K9Dw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
the "permission denied" error does make sense from a user perspective as it
details that.only roles with admin option for u2 can grant it. the patch
also LGTM.

Regards,
Pretham

On Tue, Dec 23, 2025 at 11:52 AM cca5507 <cca5507(at)qq(dot)com> wrote:

> Hi,
>
> Update some comments in v3.
>
> (CC Pretham, we discuss it in [1])
>
> [1]:
> https://www.postgresql.org/message-id/flat/CAJUn_kN%2BMhbb8fYP5xxQCq1KEziOinM6HgYx4ts_pPDnQ2y1nQ%40mail.gmail.com
>
> --
> Regards,
> ChangAo Chen
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2025-12-24 07:22:54 Re: Improve documentation of publication privilege checks
Previous Message Chao Li 2025-12-24 07:02:53 Re: Improve documentation of publication privilege checks