Postgres Pro
Downloads
Home   >   mailing lists

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 20150122173756.GG27749@momjian.us
Whole thread Raw
In response to Re: BUG #9923: "reassign owned" does not change permissions grantor  (Bruce Momjian <bruce@momjian.us>)
Responses Re: BUG #9923: "reassign owned" does not change permissions grantor  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
Tree view 
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. +

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade failure on Windows Server
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #12617: DETAIL: Could not read from file "pg_subtrans/06F8" at offset 90112: Success.