Permission Problem for DELETE

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.

Responses

Browse pgsql-general by date

  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)