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: Elliott, Patrick <patrick.elliott_at_medtronic.com>
Date: Tue, 16 Oct 2007 11:32:12 -0500
Message-ID: <3B8B6A1700202C43A89D61CE495C894E0C03A55661@MSPM1BMSGM103.ent.core.medtronic.com>

Sorry, you won't find one. The encryption is one way. If you guess the correct password, it will match the encrypted value, but the encrypted value will decrypt to many possible values. That is how encryption works.

Pat



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vincent verpoort Sent: Tuesday, October 16, 2007 10: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<mailto: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> [mailto: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
^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-.
___________________________________________________________________________________________________ CONFIDENTIALITY AND PRIVACY NOTICE Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records. To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com -- http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 16 2007 - 11:32:12 CDT

Original text of this message

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