Re: document deviation from standard on REVOKE ROLE - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: document deviation from standard on REVOKE ROLE
Date
Msg-id ZULkTidzkWWtgjak@momjian.us
Whole thread Raw
In response to Re: document deviation from standard on REVOKE ROLE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, Nov  1, 2023 at 07:49:25PM -0400, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: document deviation from standard on REVOKE ROLE
Next
From: Tom Lane
Date:
Subject: Re: Don't pass NULL pointer to strcmp().