Re: Change password/lock users

Posted by ErmanArslansOracleBlog on Jun 06, 2024; 10:50am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Change-password-lock-users-tp12550p12551.html

a custom update can be done, but it is not supported. You can also use (loop and execute it for all the relevant users) -> FND_USER_PKG.DisableUser, but it is not a perfectly supported move, and you should know what you re doing before using it.

--
-- DisableUser
--   Sets end_date to sysdate for a given user. This is to terminate that user.
--   You longer can log in as this user anymore. If username is not valid,
 --   exception raised with error message.
--

Following MOS note can help - >How To Lock Users Out Of E-Business Suite And Allow Specific Users (Doc ID 605538.1) -> Not the same thing, but it can help..