Search Postgresql Archives

change current user in pl/pgsql function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: change current user in pl/pgsql function
From: Sergey Karin <sergey.karin@xxxxxxxxx>
Date: Mon, 6 Feb 2006 15:43:30 +0300

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: change current user in pl/pgsql function
  - From: Bruno Wolff III

Prev by Date: Re: [HACKERS] Logging statements and parameter values
Next by Date: Re: change current user in pl/pgsql function
Previous by thread: old style outer joins
Next by thread: Re: change current user in pl/pgsql function
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux