Q

Code to check password and display user-defined message

When a particular user logs on to any schema, what code is to be written to check if the password is correct or wrong and display a user-defined message?

When a particular user logs on to any schema, what code is to be written to check if the password is correct or wrong and display a user-defined message? I'm using Oracle version 8.x or 9.x and Developer 2000 Forms 6i version 5.0 or 6i.
When a user signs on to the database, they supply Oracle with the userid and password. Oracle uses these two values and a secret algorithm to compute a hash value. This hash value is compared with the hash value stored in the PASSWORD column in the DBA_USERS view for the given USERNAME. If the computed hash value matches the stored hash value, then the user must have given the correct userid/password combination. If the hash values do not match, Oracle returns the following error code and message:
ORA-01017: invalid username/password; logon denied
There is no way to tell Oracle to display any specific message. However, you can code your application to display any message you want if the ORA-1017 error is received.
This was first published in March 2006

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close