Horton

Re: REFERENCES privilege should not be symmetric (was Re: [GENERAL] Postgres Permissions Article)

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

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Paul Jungwirth <pj@illuminatedcomputing.com>, PGSQL Mailing List <pgsql-general@postgresql.org>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2017-03-31T21:24:02Z
Lists: pgsql-hackers, pgsql-general 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Fri, Mar 31, 2017 at 10:40 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I think the benefit is reduction of user confusion.  Admittedly, since
>> Paul is the first person I can remember ever having complained about it,
>> maybe nobody else is confused.

> ​After going back-and-forth on this (and not being able to independently
> come to the conclusion that what we are adhering to is actually a typo) I'm
> going to toss my +1 in with Robert's.

OK, the consensus seems clearly against changing this in the back branches,
so I'll just fix it in HEAD.

			regards, tom lane

Commits

  1. For foreign keys, check REFERENCES privilege only on the referenced table.