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 first published in May 2001

Dig deeper on Oracle database security

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close