Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: getting users passwords in plain text

RE: getting users passwords in plain text

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Tue, 16 Oct 2007 12:10:29 -0400
Message-ID: <21469B88E0EA11498818517F21033531DEF596@EPRI17P32001A.csfb.cs-group.com>


Vincent,  

You haven't adequately (for me, at least) explained what you're trying to do. What exactly do you want to accomplish?  

There is no script that converts encrypted/hashed passwords to plain text, and if there were, I'm sure Oracle would be interested in hearing about it. Protected passwords are a basic component of Oracle security.  

Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vincent verpoort Sent: Tuesday, October 16, 2007 11:08 AM To: Sweetser, Joe; Oracle-L Freelists
Subject: Re: getting users passwords in plain text

i thought of doing a insert into mytable values (username,password); in the $ORACLE_HOME/rdbms/admin/utlpwdmg.sql <http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96536/ch53. htm#1005955> but i don't wanne edit or write anything more looking for a scritp that converts the hase to plain text

On 10/16/07, Sweetser, Joe <JSweetser_at_icat.com> wrote:

        Not exactly sure what you want to do, but you might google for the undocumented "alter user XXX identified by values..." command. It will let you set the passwords back to what they were without knowing them.          

        hth,         

        -joe                  


        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vincent verpoort

	Sent: Tuesday, October 16, 2007 7:14 AM
	To: Oracle-L Freelists
	Subject: getting users passwords in plain text
	
	
	Hi Experts,
	
	I have a question that's a bit unethical. 
	
	For a company i'm working for i need to find out what the
passwords are of oracle users. As changing them means a lot of work for allot of poeple.         

        Is there anyway i can clear text the password from dba database, i have sysdba and all privs.         

        any points would be nice also i want to put this into script so if anyone has something ?         

	-- 
	                           Vincent Verpoort
	
	  ,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_ 
	              Communiceren is begrepen worden 

^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-.
-- Vincent Verpoort ,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_ Communiceren is begrepen worden
^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-.

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html


--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 16 2007 - 11:10:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US