From: Richard Huxton <richardh@archonet.com>
To: Chris Travers <chris@travelamericas.com>
To: pgsql-sql@postgresql.org
Subject: Re: How to determine the currently logged on username
Date: Fri, 18 Jul 2003 15:25:51 +0100
Message-ID: <200307181525.52074.richardh@archonet.com> (raw)
In-Reply-To: <3F17F90F.5020403@travelamericas.com>
References: <3F17F90F.5020403@travelamericas.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: richardh@archonet.com, chris@travelamericas.com
Subject: Re: How to determine the currently logged on username
In-Reply-To: <200307181525.52074.richardh@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox