Password verification in 8.1.7

This tip describes how to avoid an Oracle password verification function error.

If you created a password verification function and it is attached to your user profile, then a user cannot change...

his password by altering user in Oracle 8.1.7. You will get an error as follows:

sid817 SamSQL :> Connect scott/tiger
sid817 SamSQL :> alter user scott identified by "sameer2,3";
alter user scott identified by "sameer2,3"
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed

The error ORA-28003 says password verification failed, although the password which you are supplying is according to function.

The solution for this is as follows: First, connect as SYS. Assuming that you have a password verification function called VARIFY_FUNCTION, you need to issue:

Create public synonym VARIFY_FUNCTION for SYS.VARIFY_FUNCTION;

sid817 SamSQL :> Connect scott/tiger
sid817 SamSQL :> alter user scott identified by "sameer2,3";
User altered.

For More Information


This was last published in May 2001

Dig Deeper on Oracle database security

PRO+

Content

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

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