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.
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.