Re: [SQL] How to determine the current user

2003-10-14 Thread Sean Chittenden
> 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

[SQL] How to determine the current user

2003-10-14 Thread Michael Brusser
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 curr