Thread: Return value of current_user before calling SECURITY DEFINER function.
Hello,
Is there are way to determine a subject?
Thanks.
--
// Dmitriy.
// Dmitriy.
Re: Return value of current_user before calling SECURITY DEFINER function.
From
Dmitriy Igrishin
Date:
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.
Hello
pls, try session_user2013/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.
From
Dmitriy Igrishin
Date:
2013/12/4 Pavel Stehule <pavel.stehule@gmail.com>
Hellopls, 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.
From
Dmitriy Igrishin
Date:
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>Hellopls, try session_userNot really :-(. The user can perform SET ROLE before calling the SECURITYDEFINER 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.