How to change passwords in EBS R12

One of the main duties of an App DBA is cloning EBS from Prod to Dev. It is recommended that we change the passwords  of a user on a DEV environment so that they would not be able to access the PROD.

DO NOT Change passwords on the DB level. Instead use FNDCPASS.

In this example we would change the FNDCPASS of SYSADMIN on our newly cloned EBS.

Steps

1. Login to your Application Server as applmgr
2. FNDCPASS apps/<appspassword> 0 Y system/<dbsystempassword> user SYSADMIN <newpassword>clear
3. Try it now.