Permission Problem for DELETE

[Volkan YAZICI <yazicivo@xxxxxxxxxx>]

Hi,

I've below data structure with listed permissions:

  (commsrv@xxxxxxxxxxxxx:5432/test_1_5_0_0) [2008-05-27 09:34:32]
  > \d commsrv.outgoingmessages
                    Table "commsrv.outgoingmessages"
           Column         |              Type              | Modifiers
  ------------------------+--------------------------------+-----------
   messageid              | bigint                         | not null
   ...
  Indexes:
      "pk_outgoingmessages_messageid" PRIMARY KEY, btree (messageid)
  Triggers:
      commsrv_outgoingmessages_update_for_emove
      AFTER UPDATE ON outgoingmessages
      FOR EACH ROW
      EXECUTE PROCEDURE commsrv_outgoingmessages_update_for_emove()
  
  (commsrv@xxxxxxxxxxxxx:5432/test_1_5_0_0) [2008-05-27 09:34:33]
  > \z commsrv.outgoingmessages
        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
  
  (emove@xxxxxxxxxxxxx:5432/test_1_5_0_0) [2008-05-27 09:37:17]
  > DELETE FROM commsrv.outgoingmessages WHERE messageid = 261120;
  ERROR:  permission denied for relation outgoingmessages

Any ideas about what I might be missing?


Regards.