Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: getting users passwords in plain text
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 thepasswords 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
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 16 2007 - 11:10:29 CDT
![]() |
![]() |