> I'm running Pg v7.3.4
> I have a function where I need to determine the current user.
> But since the function was created with option "SECURITY DEFINER"
> (it has to be this way) current_user returns the name of creator,
> rather than current user.
>
> Is there a way in such function find out the real current user?
CURRENT_USER should be right. SESSION_USER is the username that
connected to the DB. Look at table 6-27, session information
functions:
http://www.postgresql.org/docs/7.3/static/functions-misc.html
-sc
--
Sean Chittenden
