Re: BUG #9923: "reassign owned" does not change permissions grantor

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, Alexey Bashtanov <bashtanov@imap.cc>, pgsql-bugs@postgresql.org
Date: 2015-12-17T20:21:46Z
Lists: pgsql-bugs
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.

			regards, tom lane


Commits

  1. adjust ACL owners for REASSIGN and ALTER OWNER TO