Account Status Is Not Displayed Correctly In PDBs for Common users After locked per FAILED_LOGIN_ATTEMPTS or Gradual Password Rollover (Doc ID 2947289.1)

Last updated on JUNE 04, 2023

Applies to:

Symptoms

Changing the password of common user from CDB with GPR set present this behavior.

• From Dba_users view account_status shows “OPEN & IN ROLLOVER” in CDB and PDB.
• After the password rollover periods ends then get connected with this common user to CDB and PDB and ..
         Result in CDB Account_status shows: OPEN
         Result in PDB Account_status shows: OPEN & IN ROLLOVER    (This status is not displayed Correctly In PDB)

 Note: Also this status is not displayed Correctly if the Account  has been locked per FAILED_LOGIN_ATTEMPTS and get it unlocked the Status on PDB may not be displayed correctly.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.