| 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: | Whole Thread | Raw Message | 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 |