Permission Problem for DELETE

Поиск
Список
Период
Сортировка
Искать
От
Volkan YAZICI
Тема
Permission Problem for DELETE
Дата
в 03:39:45
Msg-id
871w3o9ro6.fsf@alamut.mobiliz.com.tr
Список
Дерево обсуждения
Permission Problem for DELETE Volkan YAZICI <yazicivo@ttmail.com>
Re: Permission Problem for DELETE Tom Lane <tgl@sss.pgh.pa.us>
Re: Permission Problem for DELETE yazicivo@ttmail.com (Volkan Yazıcı)
Re: Permission Problem for DELETE Tom Lane <tgl@sss.pgh.pa.us>
Re: Permission Problem for DELETE yazicivo@ttmail.com (Volkan Yazıcı)
Re: Permission Problem for DELETE Tom Lane <tgl@sss.pgh.pa.us>
Re: Permission Problem for DELETE yazicivo@ttmail.com (Volkan Yazıcı)
Re: Permission Problem for DELETE Volkan YAZICI <yazicivo@ttmail.com>
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 по дате отправления
От: Webb Sprague
Дата:
От: PFC
Дата:
FAQ