change current user in pl/pgsql function - Mailing list pgsql-general

From Sergey Karin
Subject change current user in pl/pgsql function
Date
Msg-id b78883bf0602060443l270c795ep@mail.gmail.com
Whole thread Raw
Responses Re: change current user in pl/pgsql function  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: [HACKERS] Logging statements and parameter values
Next
From: indu ss
Date:
Subject: Compile of Pgmail function fails