* Tom Lane ([EMAIL PROTECTED]) wrote: > Peter Eisentraut <[EMAIL PROTECTED]> 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 ...
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
signature.asc
Description: Digital signature
