Re: Access Control

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."

-- 
Mike Sherrill
Information Management Systems