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
-
adjust ACL owners for REASSIGN and ALTER OWNER TO
- ab14c1383836 9.1.20 landed
- 7af3dd540e29 9.2.15 landed
- 62e6eba8d266 9.3.11 landed
- 2c8ae6442fed 9.4.6 landed