ORA-28003, ORA-20002 while changing password

      No Comments on ORA-28003, ORA-20002 while changing password

ORA-28003, ORA-20002 while changing password
Error:
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:
—————————————
Solution 1:
———–
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# ;
User altered.

Solution 2:
—————-
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’;
PROFILE
——————————
DEFAULT

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;
Profile altered.

Now change the password.
SQL> alter user devtest identified by oracleworlds;
User altered.

 

Leave a Reply

Your email address will not be published. Required fields are marked *