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

From Boris Migo
Subject is it possible to get current_user inside security definer function ?
Date
Msg-id 000801c64143$313bba50$1e01a8c0@weasel
Whole thread Raw
Responses Re: is it possible to get current_user inside security definer function ?
List pgsql-general

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

I know that this question was discused earlier, and session_user should be the answer, but user's curren_user doesn't have to be the same as session_user before function call, because of 'set role'.
 
 
regards
justweasel

pgsql-general by date:

Previous
From: Marc Munro
Date:
Subject: Re: [pgsql-general] Daily digest v1.5986 (24 messages)
Next
From: Michael Trausch
Date:
Subject: Re: Syntax error, but where?