Skip to content
Advertisements

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.

Advertisements
One Comment Post a comment
  1. karthik #

    thanks for the explanation

    March 10, 2016

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: