Besides stating the obvious, I will add that with the resources available in certain locations depending upon where your work, NSA, CIA, etc., the answer is probably readily available.

You can however user the below query to save of the encrypted password. After doing that you can change it to whatever you want.

Although this was a nifty feature in older versions where your could 'become' someone else, (if you had alter user priv), now adays there is a 'BECOME USER' system privilege.

Well, for what it's worth:
select 'alter user &&v_user identified by values '||''''||
password||''''||';'
from DBA_USERS where username = upper('&&v_user');



-----Original Message-----
From: Keith Williams [mailto:oracledba-ezmlmshield-x26859791.[Email address protected]
Sent: Wednesday, August 31, 2005 12:26 AM
To: LazyDBA Discussion
Subject: RE: How Do I Decode The Password

There is no command to "decode" the password. That would make it pointless because everyone would simply use the decode to see each others passwords.



-----Original Message-----
From: Chandra Guptan Bose [mailto:oracledba-ezmlmshield-x84428838.[Email address protected]
Sent: Tuesday, August 30, 2005 11:21 PM
To: LazyDBA Discussion
Subject: How Do I Decode The Password

Hi Folks,



How Can We Decode Th Pasword Stored in DBA_USERS Table





C Chandra Guptan,â-ºâ-º

Software Engineer,

Datawarehousing Center.

iGATE Global Soutions,

EPIP Phase II , White Field,

Bangalore



Ph No: 080-5104 0000 Ext : 5382

Email : chandraguptan.[Email address protected] <mailto:chandraguptan.[Email address protected]

Web : http://chandraguptan.250free.com <http://chandraguptan.250free.com/> â-"â-"

Where There's A Will There's A Way ...



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



Information transmitted by this EMAIL is proprietary to iGATE Group of Companies and is intended for use only by the individual

or entity to whom it is addressed and may contain information that is privileged, confidential, or exempt from disclosure under

applicable law. If you are not the intended recipient of this EMAIL immediately notify the sender at iGATE or [Email address protected]

and delete this EMAIL including any attachments

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


IMPORTANT NOTICE:
This message may contain confidential information. If you have received this e-mail in error, do not use, copy or distribute it. Do not open any attachments. Delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page