How could I recover my passwords? I'm trying to delete a database and create a new one. I get a prompt to enter password for user: CTXSYS. But I get an error message stating insufficient privileges. And yes, I did copy the passwords from the password management console when I first installed my test database. But now it seems that all my Oracle and SQL passwords will not work. Is there a workaround?
You can view user's passwords in the PASSWORD column of DBA_USERS. Unfortunately, they are encrypted. And there is no dencrypt function for the password. If you do not know the password, sign on to the database as someone with DBA rights (SYS or SYSTEM) and change the user's password with the ALTER USER command.
You are getting an error stating that you have insufficient privileges. If you had an invalid password, then you would get the following error:
ORA-01017: invalid username/password; logon deniedBut it appears your password is correct. You are getting a different error message. You need to make sure that the user in question has the CREATE SESSION privilege or the CONNECT role. Without one of these, you will get the following error instead:
ORA-01045: user OUTLN lacks CREATE SESSION privilege; logon denied
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.