Re: GRANTing privileges to a plpgsql function doesn't

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: GRANTing privileges to a plpgsql function doesn't
Дата
Msg-id 87lliw6far.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на 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:

> Hi,
>
> 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.

Look at the WITH SECURITY DEFINER clause to CREATE FUNCTION (I think
that's where it is).

-Doug

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

Предыдущее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Prevent users from creating tables
Следующее
От: "Scot L. Harris"
Дата:
Сообщение: Re: Multiple databases on seperate drives/file systems?