Skip site navigation (1) Skip section navigation (2)

pgsql: Update per-column ACLs, not only per-table ACL,when changing ta

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Update per-column ACLs, not only per-table ACL,when changing ta
Date: 2011-12-21 23:23:53
Message-ID: E1RdVVp-0004pz-SN@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Update per-column ACLs, not only per-table ACL, when changing table owner.

We forgot to modify column ACLs, so privileges were still shown as having
been granted by the old owner.  This meant that neither the new owner nor
a superuser could revoke the now-untraceable-to-table-owner permissions.
Per bug #6350 from Marc Balmer.

This has been wrong since column ACLs were added, so back-patch to 8.4.

Branch
------
REL9_0_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/7443ab2b348d190e8784a2684a5b6ae91f7dcd4b

Modified Files
--------------
src/backend/commands/tablecmds.c |   75 ++++++++++++++++++++++++++++++++++++++
1 files changed, 75 insertions(+), 0 deletions(-)

pgsql-committers by date

Next:From: User FxjrDate: 2011-12-22 15:08:02
Subject: npgsql - Npgsql2: Fixed line endings.
Previous:From: Robert HaasDate: 2011-12-21 20:22:15
Subject: pgsql: Improve behavior of concurrent CLUSTER.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group