Re: get username of user calling function?

On 3/1/07, George Nychis <gnychis(at)cmu(dot)edu> wrote:
>
>
>
> A. Kretschmer wrote:
> > You can use the current_user - variable. Select current_user;
>
> I'm trying to create a function in which users can only kill their own
> processes, it works
> perfectly if i hardcode a username in such as this:
> CREATE FUNCTION kill_process(integer) RETURNS boolean
> AS 'select pg_cancel_backend(procpid)
> FROM (SELECT procpid FROM pg_stat_activity WHERE procpid=$1 and
> usename=''gnychis'')
> AS kill;'
> LANGUAGE SQL SECURITY DEFINER;

See the EXECUTE function in the pl/pgSQL language in the docs for dynamic
queries.

But if i try to replace usename=''gnychis'' with usename=current_user it no
> longer works.
>
> Any ideas?
>
> - George
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>