Re: How to retrieve User login name?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 02 Jul 1998 01:16:36 GMT
Message-ID: <359ddf65.1583837@192.86.155.100>

A copy of this was sent to Troy Perchotte <max_at_headroom.com> (if that email address didn't require changing) On Wed, 01 Jul 1998 16:10:13 -0700, you wrote:

>I would like to send an access pass-through query to oracle that will
>allow the user to change their password.
>
>How do I find out what the user's login name is? (so that I can fill in
>the username parameter of my "ALTER USER ... IDENTIFIED BY ..."
>statement)
>
>Thanks,
>
>Troy Perchotte

select user from dual

is one way to get it...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Jul 01 1998 - 20:16:36 CDT