Me wrote:
> Am Freitag, 2. Juli 2004 13:20 schrieb Ilir Gashi:
> > CREATE TABLE TEST(ID INTEGER,NAME VARCHAR(50));
> > INSERT INTO TEST (ID) VALUES (1);
> > GRANT UPDATE ON TEST TO TESTUSER;
> > Connect as TestUser;
> > UPDATE TEST SET NAME='TEST' WHERE ID=1;
> > ERROR: test: Permission denied.
> > UPDATE TEST SET NAME='TEST';
> > Executes successfully.
>
> According to the letter of the SQL standard, this behavior is not
> conforming.
OK, I was wrong, the behavior is correct, but the specification was hidden
somewhere in the subclauses.