Horton

Re: Why is_admin_of_role() use ROLERECURSE_MEMBERS rather thanROLERECURSE_PRIVS?

preTham <prezza672@gmail.com>

View thread
From: preTham <prezza672@gmail.com>
To: cca5507 <cca5507@qq.com>
Cc: Chao Li <li.evan.chao@gmail.com>, pgsql-hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-12-24T07:05:31Z
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@qq.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
>