Re: How to show password?

From: Peter Lewis <peter.m.lewis_at_bgs.ac.uk>
Date: Tue, 24 Nov 1998 09:49:53 +0000
Message-ID: <365A8141.4FC0E5E4@bgs.ac.uk>

A more helpful answer (perhaps...):

select username, password from dba_users where username = 'XXX'
/

Username Password

-------- ----------------
XXX      ABABABABABABABAB

This will give you the encoded password for user xxx. You can set this same password for user yyy using:-

alter user yyy identified by values 'encoded-password-string';

where 'encoded-password-string' is the value returned from the first query above.

Hope this helps.

~ Peter Lewis, Database Administrator, 
~ British Geological Survey, Keyworth, Nottingham, NG12 5GG.
~ Telephone: 0115 936 3254  Fax: 0115 936 3200
~ E-mail: peter.m.lewis@bgs.ac.uk  Web: http://www.bgs.ac.uk

--

>   Derek Chu <hkchu_at_cse.cuhk.edu.hk> wrote:

> > Dear all,
> >
> > I would like to ask how to display the password of a particular user?
> >
> > Derek
> >
Received on Tue Nov 24 1998 - 03:49:53 CST