Re: current_user in seucurity DEFINER functions - Mailing list pgsql-general

From strk
Subject Re: current_user in seucurity DEFINER functions
Date
Msg-id 20100513222605.GP99776@keybit.net
Whole thread Raw
In response to Re: current_user in seucurity DEFINER functions  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
On Thu, May 13, 2010 at 09:21:46AM +0200, Pavel Stehule wrote:
> 2010/5/13 strk <strk@keybit.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

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: autovacuum: 50% iowait for hours
Next
From: David Fetter
Date:
Subject: Re: Pulling data from a constraint def