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

Viewing passwords in Oracle

I have to accomplish a task that deals with Oracle user names and passwords. Is there any way to see the passwords in Oracle, where it will be physically stored?
There is no way to know the user's password. You can query DBA_USERS and see an encrypted form of the users password, but Oracle does not store this password anywhere. It only stores this encrypted form. This encrypted password does not have an decrypt function. It is a one-way hash function. When a user signs on to the database, they give the system their username and password. The system uses both of these values and other unknown values and runs all values through a function. It then compares the output of this function to the value found in DBA_USERS.PASSWORD. If the values matched, then the user must have supplied the correct password. If they don't, then some combination of the username and password are not correct.

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.