Skip to Main Content

Manually set password expired date for multiple users

hoanvuphanApr 21 2022

Hi all,
I am using Fusion Middleware Identity Access Mgmt
I have received a request to set password expired to yesterday (sysdate -1 ) for group of users (1000 users) . The goal is to make user after login with old password, they will be redirected to the change password page.
So is it possible to do with Java code or SQL script?
I have tried to use Oimclient code to set password expired date, but got error: usr_pwd_expire_date is a System Attribute and cannot be set through API.:usr_pwd_expire_date
I also tried to update password expired columns usr_pwd_expired, usr_pwd_expire_date in table usr, but it seems not impacted
Any idea?

Thank you very much for your help,

Post Details
Added on Apr 21 2022