Volkan YAZICI <yazicivo@xxxxxxxxxx> 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@xxxxxxxxxxxxx: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
