Home > mailing lists

Re: current_user inside SECURITY DEFINER function? - Mailing list pgsql-general

From	Stephan Szabo
Subject	Re: current_user inside SECURITY DEFINER function?
Date	July 6, 2005 13:34:03
Msg-id	20050706063313.O24892@megazone.bigpanda.com Whole thread Raw
In response to	current_user inside SECURITY DEFINER function? (Richard Hayward <richard@tortoise.demon.co.uk>)
List	pgsql-general

Tree view

On Tue, 5 Jul 2005, Richard Hayward wrote:

> Is there any way to get the name of the current user inside a PL/pgSQL
> function that is defined with security definer?

IIRC, SESSION_USER should give the original user.

pgsql-general by date:

From: Patrick.FICHE@AQSACOM.COM
Date: 06 July 2005, 13:20:27
Subject: Re: template1 problems

From: Ben-Nes Yonatan
Date: 06 July 2005, 13:34:09
Subject: Pl/PgsSQL array

Re: current_user inside SECURITY DEFINER function? - Mailing list pgsql-general

Previous

Next