From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | John Naylor <john(dot)naylor(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: document deviation from standard on REVOKE ROLE |
Date: | 2023-11-01 23:50:38 |
Message-ID: | ZULkTidzkWWtgjak@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Nov 1, 2023 at 07:49:25PM -0400, Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > On Fri, Oct 30, 2020 at 02:03:48PM -0400, John Naylor wrote:
> >> + In the SQL standard, <command>REVOKE</command> only revokes the privilege
> >> + as granted by the invoking role. In <productname>PostgreSQL</productname>,
> >> + this will also revoke privileges granted by other roles.
>
> > John, should this 2020 patch still be applied?
>
> [ raised eyebrow... ] I do not think that was ever true as written,
> and it's demonstrably not true now.
..
> Maybe there's some related point that needs to be made,
> but not that one.
Cool, thanks, closed!
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2023-11-02 00:24:20 | Re: Don't pass NULL pointer to strcmp(). |
Previous Message | Tom Lane | 2023-11-01 23:49:25 | Re: document deviation from standard on REVOKE ROLE |