Обсуждение: Return value of current_user before calling SECURITY DEFINER function.

Поиск
Список
Период
Сортировка

Return value of current_user before calling SECURITY DEFINER function.

От
Dmitriy Igrishin
Дата:
Hello,

Is there are way to determine a subject?

Thanks.

--
// Dmitriy.

Re: Return value of current_user before calling SECURITY DEFINER function.

От
Dmitriy Igrishin
Дата:
For clarity, is it possible to write a SECURITY DEFINER function which
returns a value of current_user at the moment of call?


2013/12/4 Dmitriy Igrishin <dmitigr@gmail.com>
Hello,

Is there are way to determine a subject?

Thanks.

--
// Dmitriy.




--
// Dmitriy.

Re: Return value of current_user before calling SECURITY DEFINER function.

От
Pavel Stehule
Дата:
Hello

pls, try session_user

Regards

Pavel


2013/12/4 Dmitriy Igrishin <dmitigr@gmail.com>
Hello,

Is there are way to determine a subject?

Thanks.

--
// Dmitriy.


Re: Return value of current_user before calling SECURITY DEFINER function.

От
Dmitriy Igrishin
Дата:



2013/12/4 Pavel Stehule <pavel.stehule@gmail.com>
Hello

pls, try session_user
Not really :-(. The user can perform SET ROLE before calling the SECURITY
DEFINER function and I need to know who is the caller at the time of call.
I need something like a calling_user() function...


--
// Dmitriy.

Re: Return value of current_user before calling SECURITY DEFINER function.

От
Dmitriy Igrishin
Дата:
In other words, I need to get an information about *current* role of the caller
inside the SECURITY DEFINER function.


2013/12/4 Dmitriy Igrishin <dmitigr@gmail.com>



2013/12/4 Pavel Stehule <pavel.stehule@gmail.com>
Hello

pls, try session_user
Not really :-(. The user can perform SET ROLE before calling the SECURITY
DEFINER function and I need to know who is the caller at the time of call.
I need something like a calling_user() function...


--
// Dmitriy.




--
// Dmitriy.