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 last published in April 2004

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close