Home > IT Answers > Oracle > Lost Passwords in Oracle
Sumeshs
0 pts.
 Lost Passwords in Oracle
Oracle, Security
I have joined a company very recently who deploy their product on both Oracle and SQL Server platforms. Theyt seem to have no clue about their dba access passwords for Oracle. How do I get to these passwords? Is there a backdoor or utility which can help me get the passwords on these databases? This is Oracle on Windows? Thanks for your help, Sumesh

Software/Hardware used:
ASKED: March 3, 2005  4:45 PM
UPDATED: March 7, 2005  8:41 AM
RELATED QUESTIONS
Answer Wiki:
on server: sqlplusw "/as sysdba" then change the password with alter user ...
Last Wiki Answer Submitted:  March 3, 2005  5:04 pm  by  Omynes   0 pts.
All Answer Wiki Contributors:  Omynes   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi,

There is no way of getting passwords from the Oracle database. If you need a specific user and does not know the password, neither want to change it, you can do a select on the dba_users views and take a look at the password. This value you can use to “reset” the password with alter user … identified by values ‘….’. You can give the user temporary another password that way.

Greetz.

DutchDBA
 0 pts.