Re: GRANTing privileges to a plpgsql function doesn't give required result (pg 7.3.4)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: GRANTing privileges to a plpgsql function doesn't give required result (pg 7.3.4)
Дата
Msg-id 12339.1078025747@sss.pgh.pa.us
обсуждение исходный текст
Ответ на GRANTing privileges to a plpgsql function doesn't give required result (pg 7.3.4)  ("Greg" <greg.wickham@grangenet.net>)
Список pgsql-general
"Greg" <greg.wickham@grangenet.net> writes:
> When GRANTing execute to a plpgsql function it
> appears to run with the priviledge of the user and
> NOT with the priviledges of the owner of the function.

That's what it's supposed to do.  See the SECURITY DEFINER
option of CREATE FUNCTION for the other behavior.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump and pg_dumpall fail when trying to backup database
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dumpall dies