Thread: change current user in pl/pgsql function

Hi, List!

I use PG8.1

Are there any abilities to change current user during pl/pgsql function execution?
I developed function that have 'security definer' option and created under superuser. But for executing some command in the function I need to change user to session_user and after execotion change user to superuser.

Sergey Karin

On Mon, Feb 06, 2006 at 15:43:30 +0300,
  Sergey Karin <sergey.karin@gmail.com> wrote:
> Hi, List!
>
> I use PG8.1
>
> Are there any abilities to change current user during pl/pgsql function
> execution?
> I developed function that have 'security definer' option and created under
> superuser. But for executing some command in the function I need to change
> user to session_user and after execotion change user to superuser.

You can probably do what you want by having the top level function
run with the caller's security and have it call security definer functions
as necessary.