Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavel Stehule
Subject Re: current_user in seucurity DEFINER functions
Date
Msg-id AANLkTino-XGdLmVORSKEq14fHy9b___MEso3QbN3Q9EQ@mail.gmail.com
Whole thread Raw
In response to current_user in seucurity DEFINER functions  (strk <strk@keybit.net>)
Responses Re: current_user in seucurity DEFINER functions  (strk <strk@keybit.net>)
List pgsql-general
Tree view 
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

regards
Pavel Stehule
>


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

pgsql-general by date:

Previous
From: Leonardo F
Date:
Subject: Authentication method for web app
Next
From: Brian Modra
Date:
Subject: Clustering, parallelised operating system, super-computing