Re: Permission Problem for DELETE

Hi,

I rarely use GRANT -- nearly once every 1-2 year -- and everytime I
forget this small detail: DELETE/INSERT/UPDATE privileges require SELECT
privilege also.

On Tue, 27 May 2008, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> You don't have SELECT privilege, which is required to read any of the
> columns in the WHERE clause.

As far as I tested, even

DELETE FROM foo;
UPDATE foo SET bar = NULL;

commands _require_ SELECT permissions.

> (Not sure if this is explained anywhere in our manual :-(, but the
> behavior is required by SQL spec.)

Would attached patch be a first step for that purpose?

Regards.