In real time environments, we might have the requirement to force all apps users to change their passwords after certain period of time so we can force them to do so by using below.
Either to run Sql Script like below or same you can achieve by submitting concurrent request.
sqlplus -s APPS/<pwd> @AFCPEXPIRE.sql
or
Submit concurrent request: CP SQL*Plus Expire FND_USER Passwords
Above script sets the fnd_user.password_date to null for all users which causes all user passwords to expire. It can also be run as a SQL*Plus concurrent program. The user will need to create a new password upon the next login.
For further detail please see Metalink ID # 414976.1
No comments:
Post a Comment