From: | Volkan YAZICI <yazicivo(at)ttmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Permission Problem for DELETE |
Date: | 2008-05-27 06:39:37 |
Message-ID: | 871w3o9ro6.fsf@alamut.mobiliz.com.tr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I've below data structure with listed permissions:
(commsrv(at)192(dot)168(dot)1(dot)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(at)192(dot)168(dot)1(dot)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(at)192(dot)168(dot)1(dot)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(at)192(dot)168(dot)1(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | PFC | 2008-05-27 08:19:37 | Re: [PERFORM] select query takes 13 seconds to run with index |
Previous Message | Webb Sprague | 2008-05-27 04:11:20 | Re: Populating a sparse array piecemeal in plpgsql (REDUX) |