reset password

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

reset password

Roshan
Hi Erman,

all users login passwords have been reset. Do you know how it is possible? How I can revert back?
It is on production instance.

Regards,
Roshan
Reply | Threaded
Open this post in threaded view
|

Re: reset password

ErmanArslansOracleBlog
Administrator
To change all user password read:
How to Change Applications Passwords using Applications Schema Password Change Utility (FNDCPASS or AFPASSWD) (Doc ID 437260.1)
->
The SYSTEM token is used when changing the APPLSYS password.
The ORACLE token is used when changing a SINGLE Applications schema password.
The ALLORACLE token is used when changing ALL Applications schema passwords.
The USER token is used when changing an Applications USER password.

As for reverting backup, take a backup of the database before changing the password, and restore it if necessary...

Or alternatively, you can backup the following tables and restore them if needed..
FND_USER and FND_ORACLE_USERID .