Tip :- How to get rid of ORA-28003 password verification error while altering user ?

If you created a password verification function and it is attached with your user’s profile. Then user can not change his password by alter user in oracle 8.1.7 . You will get ORA-28003 error .

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 say password verification failed , although the password which you supplied has been fulfilling all the verification rules of the function.

The solution for this is

Connect as SYS

Assuming that you have a password verification function called VERIFY_FUNCTION,

you need to issue:

Create public synonym VERIFY_FUNCTION for SYS.VERIFY_FUNCTION;

sid817 SamSQL :> Connect scott/tiger

sid817 SamSQL :> alter user scott identified by "sameer2,3";

User altered.

User SCOTT in above case must have alter user privilege.

End of Tip	Welcome to send comments or feedback at Wadhwa_s@Hotmail.com
Sameer Wadhwa	Copyright © Oracle Techniques All Rights Reserved