Re: Grant Update (Possible bug)?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Ilir Gashi <I(dot)Gashi(at)city(dot)ac(dot)uk>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Grant Update (Possible bug)?
Date: 2004-07-02 16:52:42
Message-ID: 15773.1088787162@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> According to the letter of the SQL standard, this behavior is not conforming.
> But PostgreSQL enforces that you need SELECT privilege for columns that you
> read for the purpose of performing an UPDATE.

Why do you think it's non-conformant? AFAICS SQL92 section 6.4 <column
reference> Access Rule 1(a) requires exactly this behavior.

I notice that Annex E item 5 points this out as an incompatibility with
SQL89 ... maybe Oracle is still on SQL89 ...

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephen Frost 2004-07-02 17:02:56 Re: Grant Update (Possible bug)?
Previous Message Tom Lane 2004-07-02 16:34:50 Re: timestamp arithmetic (a possible bug?)