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

Предыдущее
От: "Webb Sprague"
Дата:
Сообщение: Re: Populating a sparse array piecemeal in plpgsql (REDUX)
Следующее
От: PFC
Дата:
Сообщение: Re: [PERFORM] select query takes 13 seconds to run with index