Re: Can the username calling a function be made available within the function?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Can the username calling a function be made available within the function?
Дата
Msg-id 20040407135657.GB13185@wolff.to
обсуждение исходный текст
Ответ на Can the username calling a function be made available within the function?  (Adam Witney <awitney@sghms.ac.uk>)
Список pgsql-general
Дерево обсуждения 
On Wed, Apr 07, 2004 at 11:23:25 +0100,
  Adam Witney <awitney@sghms.ac.uk> wrote:
>
> I'd like to be able to have a PL/pgSQL function defined as SECURITY DEFINER,
> but still have access to the calling username within the function. Is this
> possible?
>
> I could pass current_user as a parameter, but of course this could easily be
> bypassed.
>
> Is there a way of coding this?

You probably want session_user.

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

Предыдущее
От: Mike Nolan
Дата:
Сообщение: Re: Can we have time based triggers in Postgresql??
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Can we have time based triggers in Postgresql??