Description:
When changing a resource's password via the Clarity Admin Tool, the Last_Pwd_Change field in the cmn_sec_users table is not updated.
It becomes an issue when GEL scripts are using a dedicated XOG user Id that is not able to log in due to the password change or being expired.
In some cases the dedicated XOG user is not used to log into the Clarity UI therefore Clarity Administrators need to be able to change the password via the
Clarity Admin Tool and have the Last_Pwd_Change field updated to allow the GEL script to log in.
Steps to reproduce:
Expected result: Gel script is able to log into Clarity and complete the XOG
Actual result: Last_Pwd_Change field is not updated, GEL still sees password as expired and cannot log in.
Solution:
Workaround:
The work around is to log into Clarity as the affected user and change the password via the Account Settings.
Or to run a DB query to manually set LAST_PWD_CHANGE date in the CMN_SEC_USERS table.
Status/Resolution:
Resolved in Clarity 12.1.0 Generic Patch. Reference TEC542313.
Resolved in Clarity 13.1.0
Keywords: CLARITYKB, CLRT-66396, clarity12resolved, clarity13resolved, clarity1310resolved.