Re: BUG #9923: "reassign owned" does not change permissions grantor
Bruce Momjian <bruce@momjian.us>
From: Bruce Momjian <bruce@momjian.us>
To: Alexey Bashtanov <bashtanov@imap.cc>
Cc: pgsql-bugs@postgresql.org
Date: 2015-01-22T17:37:56Z
Lists: pgsql-bugs
On Fri, Jan 9, 2015 at 01:19:48PM -0500, Bruce Momjian wrote: > I can confirm this bug report from April, and your analysis of the fixes > --- we were missing calls to aclnewowner() for types, foreign servers, > and foreign data wrappers, for both REASSIGN and ALTER OWNER TO. > > With the attached SQL script you can see the ACL fields properly > changing to match the object owner (attached). Without the patch, only > the table's ACL changes. > > The patch also changes the regression output --- I think that is because > the object ownership changes remove certain duplicates from the ACL > list. Patch applied. Thank you for the excellent bug report. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
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