Re: is it possible to get current_user inside security definer function ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: is it possible to get current_user inside security definer function ?
Дата
Msg-id 13906.1141711109@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: is it possible to get current_user inside security definer function ?  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: is it possible to get current_user inside security definer function ?
Список pgsql-general
Дерево обсуждения 
Michael Fuhr <mike@fuhr.org> writes:
> Is this what you're after?  I don't know if there's another way.

>     role_user := current_setting('role');

We currently define the spec's CURRENT_ROLE as equivalent to
CURRENT_USER, but I wonder if it shouldn't do what Boris is after.

            regards, tom lane

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: is it possible to get current_user inside security definer function ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: JSP pages don't work with database after postgres downgrade