Re: Permission Problem for DELETE

On Tue, 27 May 2008, Volkan YAZICI <yazicivo(at)ttmail(dot)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(at)192(dot)168(dot)1(dot)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(at)192(dot)168(dot)1(dot)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.