Change password/lock users

[VinodN]

Hi Erman, is it possible to reset password/lock account of all application users with one single command?

[ErmanArslansOracleBlog]

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..

[VinodN]

Thanks Erman!