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.