Ask the Expert

Username/password conditions

1. Can we make the user and/or password case sensitive?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: