Re: How to retrieve User login name?

>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

Somwhere along the line, execute the query select user from dual and save the result. Received on Wed Jul 01 1998 - 20:44:54 CDT