Postgres Pro
Downloads
Home   >   mailing lists

How to determine the current user - Mailing list pgsql-sql

From Michael Brusser
Subject How to determine the current user
Date
Msg-id DEEIJKLFNJGBEMBLBAHCAEKCDMAA.michael@synchronicity.com
Whole thread Raw
Responses Re: How to determine the current user  (Sean Chittenden <sean@chittenden.org>)
List pgsql-sql
Tree view 
I'm running Pg v7.3.4 
I have a function where I need to determine the current user.
But since the function was created with option "SECURITY DEFINER" 
(it has to be this way) current_user returns the name of creator,
rather than current user.

Is there a way in such function find out the real current user?

Thanks,
Mike.

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: get diagnostics not supported by ecpg?
Next
From: Sean Chittenden
Date:
Subject: Re: How to determine the current user