Re: Permission Problem for DELETE

On Tue, 27 May 2008, Volkan YAZICI <yazicivo@ttmail.com> writes:
> PostgreSQL doesn't allow me to DELETE a row from
> commsrv.outgoingmessages with emove role.

By the way, I just learnt that I cannot do INSERT too.

  (emove@192.168.1.160:5432/test_1_5_0_0) [2008-05-27 14:47:01]
  > INSERT INTO commsrv.outgoingmessages
         SELECT messageid+1, vendorid, ...
           FROM commsrv.outgoingmessages
       ORDER BY messageid DESC
          LIMIT 1;
  ERROR:  permission denied for relation outgoingmessages

I suspected, schema permissions first...

  (emove@192.168.1.160:5432/test_1_5_0_0) [2008-05-27 14:46:58]
  > \dn+ commsrv
                                List of schemas
    Name   | Owner |             Access privileges              | Description
  ---------+-------+--------------------------------------------+-------------
   commsrv | test  | {test=UC/test,commsrv=U/test,emove=U/test} |

But this doesn't look like to be the case.

Does anybody have an idea? What might I be missing? I'll be really
really appreciated for any kind of help.


Regards.