Forum Stats

  • 3,816,413 Users
  • 2,259,185 Discussions


Manually set password expired date for multiple users

hoanvuphan Member Posts: 28 Blue Ribbon

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,