Permission Problem for DELETE
От | Volkan YAZICI |
---|---|
Тема | Permission Problem for DELETE |
Дата | |
Msg-id | 871w3o9ro6.fsf@alamut.mobiliz.com.tr обсуждение исходный текст |
Ответы |
Re: Permission Problem for DELETE
Re: Permission Problem for DELETE |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: