PIPER-Rx - Force password to expire

PIPER-Rx
Oracle E-Business Suite Resource Centre

Did You Know - It Is Possible To Force An Applications User’s Password To Expire

How to force a user’s password to expire

It is possible to force a user’s password to expire requiring them to reset their password when they next connect.

NOTE: THIS PROCESS IS INFORMATIONAL ONLY AND IS ABSOLUTELY NOT A RECOMMENDED PROCESS – YOU MUST NEVER DIRECTLY CHANGE A BASE TABLE USING SQL

By setting the users password_date in APPLSYS.FND_USER to null, don’t forget the table audit columns…. The next time the user connects they will be forced to reset their password. 

 UPDATE FND_USER
    SET password_date = null,
        last_update_date = sysdate,
        last_updated_by = 0, -- 0 is SYSADMIN
        last_update_login = 0 -- 0 is SYSADMIN
  WHERE user_id = [USER_ID];
WHERE [USER_ID] is the user ID of the user who’s password you want to reset.

Why would you do this?

Security breach and you want to force a reset of a large number of passwords - Under audit supervision of course

WARNING - BEFORE YOU DO ANYTHING

It is never recommended to manually alter any structure or data within the E-Business Application. If you choose to do so, it is AT YOUR OWN RISK. Please refer to our Disclaimer.

Last update: May 2009