Re: How to determine the currently logged on username

From: Richard Huxton <richardh(at)archonet(dot)com>
To: Chris Travers <chris(at)travelamericas(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to determine the currently logged on username
Date: 2003-07-18 14:25:51
Message-ID: 200307181525.52074.richardh@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Friday 18 July 2003 14:41, Chris Travers wrote:
> Hi all;
>
> I will be writing a stored proceedure that will allow a currently logged
> in user to change his/her password. The function needs to be only able
> to change the password of the currently logged in user, so it will only
> take a varchar() argument and needs to look up the username of the
> currently logged in user. How do I do this? Any ideas?

select CURRENT_USER;

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Cristian Cappo 2003-07-18 14:52:02 How access to array component
Previous Message Chris Travers 2003-07-18 13:41:35 How to determine the currently logged on username