Postgres Pro
Downloads
Home   >   mailing lists

Re: is it possible to get current_user inside security definer function ? - Mailing list pgsql-general

From Tom Lane
Subject Re: is it possible to get current_user inside security definer function ?
Date
Msg-id 13906.1141711109@sss.pgh.pa.us
Whole thread Raw
In response to Re: is it possible to get current_user inside security definer function ?  (Michael Fuhr <mike@fuhr.org>)
Responses Re: is it possible to get current_user inside security definer function ?
List pgsql-general
Tree view 
Michael Fuhr <mike@fuhr.org> writes:
> Is this what you're after?  I don't know if there's another way.

>     role_user := current_setting('role');

We currently define the spec's CURRENT_ROLE as equivalent to
CURRENT_USER, but I wonder if it shouldn't do what Boris is after.

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: is it possible to get current_user inside security definer function ?
Next
From: Tom Lane
Date:
Subject: Re: JSP pages don't work with database after postgres downgrade