I am connected as internal and if I want to connect as another database user without knowing the passward.How I can do this?At the end this should be able to reset the password to its original password. Is there any way/script to do this.
1. See the encrypted password from dba_users and note it down.
2. Change the password of the user using alter user command.
3. Login to the user and do the changes you want.
4. Issue the following command:
alter user username identified by values '
Once you do these things, then Oracle recognises the old password.