Tuesday, October 7, 2014

DBA | Technical Trick: How to reset a sysadmin password (or any application user) without having an access to the application

To reset the (Sysadmin) password or any application user First: you must have the following three points:

DB user (APPS) password 
DB user (System) password

FTP Connection to the DB

Login to the DB using any FTP tool (putty)
write this command: FNDCPASS apps/apps 0 Y system/manager USER sysadmin sysadmin

Note: the passwords highlighted in Yellow is your passwords of the project.