| From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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 17:47:17 |
| Message-ID: | abrlJRPovgwR6J0J@nathan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-sql |
On Wed, Mar 18, 2026 at 12:36:17PM -0400, Tom Lane wrote:
> 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
Thanks for reviewing.
> + ... 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)
This crossed my mind when copy/pasting from the "GRANT on Roles" section,
but I obviously didn't do anything about it. Fixed in the attached.
--
nathan
| Attachment | Content-Type | Size |
|---|---|---|
| v4-0001-Allow-choosing-specific-grantors-via-GRANT-REVOKE.patch | text/plain | 18.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kirill Reshke | 2026-03-18 17:55:22 | Re: BUG #19435: Error: "No relation entry for relid 2" Triggered by Complex Join with Self-Referencing Tables |
| Previous Message | Tom Lane | 2026-03-18 16:36:17 | Re: Revoke Connect Privilege from Database not working |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2026-03-18 17:58:55 | Re: Revoke Connect Privilege from Database not working |
| Previous Message | Tom Lane | 2026-03-18 16:36:17 | Re: Revoke Connect Privilege from Database not working |