Postgres Pro
Downloads
Home   >   mailing lists

Re: Grant Update (Possible bug)? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Grant Update (Possible bug)?
Date
Msg-id 15773.1088787162@sss.pgh.pa.us
Whole thread Raw
In response to Re: Grant Update (Possible bug)?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Grant Update (Possible bug)?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-bugs
Tree view 
Peter Eisentraut <peter_e@gmx.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: timestamp arithmetic (a possible bug?)
Next
From: Stephen Frost
Date:
Subject: Re: Grant Update (Possible bug)?