Problem solve Get help with specific problems with your technologies, process and projects.

Recovering passwords

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 denied
But 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

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.