Re: Permission Problem for DELETE

Volkan YAZICI <yazicivo(at)ttmail(dot)com> writes:
> Access privileges for database "test_1_5_0_0"
> Schema | Name | Type | Access privileges
> ---------+------------------+-------+---------------------
> commsrv | outgoingmessages | table | test=arwdxt/test
> : emove=ad/test
> : commsrv=arwdxt/test
> (1 row)

> PostgreSQL doesn't allow me to DELETE a row from
> commsrv.outgoingmessages with emove role.

> (emove(at)192(dot)168(dot)1(dot)160:5432/test_1_5_0_0) [2008-05-27 09:37:11]
>>>> EXPLAIN DELETE FROM commsrv.outgoingmessages WHERE messageid = 261120;
> ERROR: permission denied for relation outgoingmessages

You don't have SELECT privilege, which is required to read any of the
columns in the WHERE clause.

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

regards, tom lane