Re: current_user inside SECURITY DEFINER function?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Richard Hayward <richard(at)tortoise(dot)demon(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: current_user inside SECURITY DEFINER function?
Date: 2005-07-06 13:33:58
Message-ID: 20050706063313.O24892@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Witney 2005-07-06 13:34:03 Re: current_user inside SECURITY DEFINER function?
Previous Message Patrick.FICHE 2005-07-06 13:20:24 Re: template1 problems