Q

Username/password conditions

1. Can we make the user and/or password case sensitive? 2. Ordinary username and password will be stored in data

dictionary until he receives sys privilege, right? You cannot make Oracle's username or passwords case sensitive. The functionality simply is not there.

Oracle does not store the user's password. If you query DBA_USERS, you will see two columns, USERNAME and PASSWORD. You will be able to clearly see the user's name. However, the password is an encrypted, one-way hash. There is no inverse function for this. So what you see will not be readable. This information is stored as soon as the user is created.

This was first published in April 2004

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close