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@xxxxxxxx> 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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *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 ^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-.