Postgres Pro
Downloads
Home   >   mailing lists

Re: Return value of current_user before calling SECURITY DEFINER function. - Mailing list pgsql-general

From Dmitriy Igrishin
Subject Re: Return value of current_user before calling SECURITY DEFINER function.
Date
Msg-id CAAfz9KPNeurcUW69tMJpTy3zVnQB0CNteGpdhA=gtd_rQPYqqQ@mail.gmail.com
Whole thread Raw
In response to Re: Return value of current_user before calling SECURITY DEFINER function.  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: Return value of current_user before calling SECURITY DEFINER function.
Next
From: Albe Laurenz
Date:
Subject: Re: Postgres 9.3 read block error went into recovery mode