Re: current_user in seucurity DEFINER functions

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: current_user in seucurity DEFINER functions
Date: 2010-05-13 07:21:46
Message-ID: AANLkTino-XGdLmVORSKEq14fHy9b___MEso3QbN3Q9EQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

regards
Pavel Stehule
>

> --strk;
>
>  ()   Free GIS & Flash consultant/developer
>  /\   http://strk.keybit.net/services.html
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Modra 2010-05-13 08:36:20 Clustering, parallelised operating system, super-computing
Previous Message Leonardo F 2010-05-13 07:21:18 Authentication method for web app