Postgres Pro
Downloads
Home   >   mailing lists

Re: get username of user calling function? - Mailing list pgsql-general

From George Nychis
Subject Re: get username of user calling function?
Date
Msg-id 45E70EE1.6010303@cmu.edu
Whole thread Raw
In response to Re: get username of user calling function?  ("David Legault" <legault.david@gmail.com>)
Responses Re: get username of user calling function?  ("David Legault" <legault.david@gmail.com>)
List pgsql-general
Tree view 

David Legault wrote:
>
>
> See the EXECUTE function in the pl/pgSQL language in the docs for dynamic
> queries.
>
So it turns out that in a SECURITY DEFINER the current_user is the owner of the function.
  I had to use session_user and it works now :)

- George

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: supporting 2000 simultaneous connections.
Next
From: Palle Girgensohn
Date:
Subject: Re: /libexec/ld-elf.so.1: Shared object "libpq.so.4" not found