ORA-28003: password verification for the specified password failed
Hi I want to explain about why ORA-28003 errors occur when you are change the password. because Some of the Oracle users assigned profile for limit password function so in this case you couldnot change your Oracle user password.If you’re not assigned the password profile function, the users can able to change the password easily.
Example :-
SQL> conn sys/sys@azar as sysdba
Connected.
SQL> create user xxx identified by xxx;
User created.
SQL> grant connect to xxx;
Grant succeeded.
SQL> conn xxx/xxx;
Connected.
SQL> alter user xxx identified by test;
User altered.
SQL> conn xxx/test;
Connected.
SQL> conn xxx/xxx;
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
So you can change the password after login users account. The below steps shown How to setup limit password function and then you cannot change password.
Step 1: Create Function
1 create or replace function pwd_change(
2 username varchar2,
3 password varchar2,
4 old_password varchar2) return boolean is
5 begin
6 raise_application_error(-20009,’Error: You cannot change password’);
7* end;
SQL> /
Function created.
Step 2: Create Profile. This profile will containg limit Password function and then you can apply this profile who are not allowed to change their password.
SQL> create profile testpwd limit password_verify_function pwd_change;
Profile created.
Step 3: Create User and assign profile.
SQL> CREATE USER TRIAL IDENTIFIED BY TRIAL DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK;
User created.
SQL> grant connect to trial;
Grant succeeded.
SQL> alter user trial profile testpwd;
User altered.
SQL> CONN TRIAL/TRIAL;
Connected.
SQL> alter user TRIAL identified by test replace TRIAL;
alter user TRIAL identified by test replace TRIAL
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20009: Error: You cannot change password
and tried to change the password as sys user ,you cannot.
SQL> conn sys/sys@azar as sysdba
Connected.
SQL> alter user trial identified by test;
alter user trial identified by test
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20009: Error: You cannot change password.
How to Fix this Error If you want to change the password.
Conn sys user.
SQL> conn sys/sys@azar as sysdba
Connected.
SQL> select profile from dba_users where username=’TRIAL’;
PROFILE
——————————
TESTPWD
SQL> select RESOURCE_NAME,RESOURCE_TYPE,LIMIT FROM DBA_PROFILES WHERE PROFILE=’TESTPWD’ AND RESOURCE_NAME=’PASSWORD_VERIFY_FUNCTION’;
RESOURCE_NAME RESOURCE
——————————– ——–
LIMIT
—————————————-
PASSWORD_VERIFY_FUNCTION PASSWORD
PWD_CHANGE
SQL> ALTER PROFILE TESTPWD LIMIT PASSWORD_VERIFY_FUNCTION NULL;
Profile altered.
SQL> alter user trial identified by test;
User altered.
SQL> conn trial/test;
Connected.
DBA 
