Re: Revoke Connect Privilege from Database not working

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "Ing(dot) Marijo Kristo" <marijo(dot)kristo(at)icloud(dot)com>, PostgreSQL Bug List <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Revoke Connect Privilege from Database not working
Date: 2026-03-18 16:36:17
Message-ID: 770633.1773851777@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-sql

Nathan Bossart <nathandbossart(at)gmail(dot)com> writes:
> I went ahead and tried adding docs, tests, and a commit message.

Thanks! I was about to conclude that "silence means assent" and
do that work, but you beat me to it. Your changes look fine,
except that where you have

+ ... A role can only attribute a grant
+ to another role if they possess the privileges of that role.

the word "possess" seems a little ambiguous --- it's not clear whether
it means SET or INHERIT privileges. The grammar nerd in me doesn't
like "they" either. How about s/they possess/it inherits/ ?
(likewise in revoke.sgml)

> The
> documentation for these commands might need a revamp. They seem to meander
> a bit, probably due to decades of organic development. But that's probably
> not this patch's problem.

Agreed, seems like a task for another day.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nathan Bossart 2026-03-18 17:47:17 Re: Revoke Connect Privilege from Database not working
Previous Message Ana Almeida 2026-03-18 14:54:23 RE: Segmentation fault in PostgreSQL 17.7 during REINDEX TABLE CONCURRENTLY

Browse pgsql-sql by date

  From Date Subject
Next Message Nathan Bossart 2026-03-18 17:47:17 Re: Revoke Connect Privilege from Database not working
Previous Message Nathan Bossart 2026-03-18 00:50:33 Re: Revoke Connect Privilege from Database not working