ORA-28003, ORA-20002 while changing password
While changing user password ORA-28003 and ORA-20002 raised.
sys@prod1>alter user DEVTEST identified by oracleworlds;
alter user DEVTEST identified by oracleworlds
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20002: Password length less than 15
Cause of The problem:
There is a password verify function allotted on the profile of the user. The verify function doesn’t allow for alter password to and it defines password length less than 15.
Solution of The Problem:
Change the password as it’s required in the password verify function. Suppose if function restriction is password to length at least 15 characters, must have one number and one alphanumeric character and one special character then change the password as following,
SQL> alter user Devtest identified oracleworlds123# ;
If you don’t care about password verification function then you may disable the function.
To do it first look for the user profile for which you get the error.
SQL> select profile from dba_users where username=’DEVTEST’;
Then look for the assigned function of the particular profile.
SQL>select RESOURCE_NAME,RESOURCE_TYPE,LIMIT from dba_profiles where PROFILE=’DEFAULT’ and RESOURCE_NAME=’PASSWORD_VERIFY_FUNCTION’;
RESOURCE_NAME RESOURCE LIMIT
——————————– ——– —————————————-
PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION
Either assigned another function of disable the verification function. You can disable it by,
SQL> alter profile default limit PASSWORD_VERIFY_FUNCTION NULL;
Now change the password.
SQL> alter user devtest identified by oracleworlds;