Re: Access Control

Mike Sherrill <MSherrill_at_compuserve.com> wrote in message news:<5p7asu4t0400f1vcbkvs7gac9ov32fc9os_at_4ax.com>...

Got it! Thanks eveybody. You safe me from another tricky question.

Thanks
K.Y. Fung

> On Sat, 02 Nov 2002 15:45:43 GMT, "Tibor Karaszi"
> <tibor_not_pressed_ham_.karaszi_at_cornerstone.se> wrote:
>
> [snip]
> >I couldn't find anything in the ANSI standard about this, after a quick
> >look.
>
> I think you're on target. I found this in the documentation of the
> GRANT UPDATE statement in Mimer SQL. The docs seem to say this
> behavior complies with SQL-92 and X/Open-95.
>
> "Allows the ident to update the table or view identified by
> table-name. If a column name list is supplied, the access is
> restricted to the specified columns, otherwise the access applies to
> the entire table (including any new columns subsequently added).
>
> "If a selective update is specified, involving a WHERE clause,
> appropriate privileges must also to held to permit execution of the
> search-condition, otherwise the update operation will fail."
Received on Mon Nov 04 2002 - 04:24:26 CET