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 по дате отправления: