is it possible to get current_user inside security definer function ?

Поиск
Список
Период
Сортировка
От Boris Migo
Тема is it possible to get current_user inside security definer function ?
Дата
Msg-id 000801c64143$313bba50$1e01a8c0@weasel
обсуждение исходный текст
Ответы Re: is it possible to get current_user inside security definer function ?  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general

Is there any way to get the name of the current user inside a plpgsql function that is defined with security definer?

I know that this question was discused earlier, and session_user should be the answer, but user's curren_user doesn't have to be the same as session_user before function call, because of 'set role'.
 
 
regards
justweasel

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

Предыдущее
От: Marc Munro
Дата:
Сообщение: Re: [pgsql-general] Daily digest v1.5986 (24 messages)
Следующее
От: Michael Trausch
Дата:
Сообщение: Re: Syntax error, but where?