Hi,
I've below data structure with listed permissions:
(commsrv@192.168.1.160: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@192.168.1.160: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@192.168.1.160: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@192.168.1.160: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.