* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > According to the letter of the SQL standard, this behavior is not confo=
rming.
> > But PostgreSQL enforces that you need SELECT privilege for columns that=
you=20
> > read for the purpose of performing an UPDATE.
>=20
> Why do you think it's non-conformant? AFAICS SQL92 section 6.4 <column
> reference> Access Rule 1(a) requires exactly this behavior.
>=20
> I notice that Annex E item 5 points this out as an incompatibility with
> SQL89 ... maybe Oracle is still on SQL89 ...
It would seem reasonable, then, that a grant of update privilege would
imply a grant of select privilege. Currently this isn't the case.
Stephen