Re: BUG #9923: "reassign owned" does not change permissions grantor - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #9923: "reassign owned" does not change permissions grantor
Date
Msg-id 20151217202304.GB27799@momjian.us
Whole thread Raw
In response to Re: BUG #9923: "reassign owned" does not change permissions grantor  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #9923: "reassign owned" does not change permissions grantor
List pgsql-bugs
On Thu, Dec 17, 2015 at 03:21:46PM -0500, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Backpatching seems fine to me.  I was just concerned if anyone was
> > relying on the existing buggy behavior.
>
> Seems unlikely.  Even if they are, the potential for catalog corruption
> later seems to trump that argument.
>
> > We do list this item as a 9.5
> > incompatibility, so the question is whether we can add an
> > incompatibility to back branches:
>
> >       Fix <link linkend="SQL-REASSIGN-OWNED"><command>REASSIGN OWNED</></>
> >       and <link linkend="SQL-ALTERTYPE"><command>ALTER OWNER TO</></>
> >       to properly update permissions lists (ACLs) when changing ownership of
> >       types, foreign data wrappers, and foreign servers (Bruce Momjian)
>
> Actually, I guess we should take out that 9.5 release note item altogether
> if we back-patch this.

Yes, that was one of my points.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription                             +

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #9923: "reassign owned" does not change permissions grantor
Next
From: mayan.murad@kronos.com
Date:
Subject: BUG #13825: JDBC Driver Connection Pool Issue