Re: Grant Update (Possible bug)? - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: Grant Update (Possible bug)?
Date
Msg-id 200407021714.02511.peter_e@gmx.net
Whole thread Raw
In response to Re: Grant Update (Possible bug)?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Possible bug?
Next
From: Tom Lane
Date:
Subject: Re: Possible bug?