Q
Problem solve Get help with specific problems with your technologies, process and projects.

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.

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close