Re: current_user in seucurity DEFINER functions

From: strk <strk(at)keybit(dot)net>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: current_user in seucurity DEFINER functions
Date: 2010-05-13 22:26:05
Message-ID: 20100513222605.GP99776@keybit.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, May 13, 2010 at 09:21:46AM +0200, Pavel Stehule wrote:
> 2010/5/13 strk <strk(at)keybit(dot)net>:
> > In a security definer function current_user yelds the
> > name of the function definer rather than invoker.
> > Is it possible to fetch the invoker name instead ? How ?
> >
> > Thanks in advance.
>
> try to use session_user

That's it. Thank you!

--strk;

() Free GIS & Flash consultant/developer
/\ http://strk.keybit.net/services.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-05-13 22:39:18 Re: List traffic
Previous Message Scott Marlowe 2010-05-13 22:23:38 Re: autovacuum: 50% iowait for hours