Login  Register

reset password

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

reset password

Roshan
1294 posts
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
| More
Print post
Permalink

Re: reset password

ErmanArslansOracleBlog
Administrator
5731 posts
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 .