A standard method is to change the password in the account, then set it back to the original using the encrypted value after the task is done. I don't recall the details since it's been many years since I used it. Would this meet your needs? Mike Hand ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Vincent verpoort Sent: Tuesday, October 16, 2007 9: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 ^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-.