Re: How to show password?

Peter Lewis ¼¶¼g©ó¤å³¹ <365A8141.4FC0E5E4_at_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.

No. Oracle's security mechanism uses both USERNAME and PASSWORD as encrption source text.
If you do so, the user yyy can't login any more. The following scrip shows it:

create user xxx identified by centaurus; create user yyy identified by centaurus; select username, password from sys.dba_users where username in ('XXX', 'YYY');

USERNAME                       PASSWORD
------------------------------ ------------------------------
YYY                            42579FA24408BCBD
XXX                            FD2F836769456378