Become Another User

[r_sonakiya]

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.

Database: Oracle8i
OS: WinNT4.0 SP6a

Thanks
Ravi

[oravijay]

Hi,

You will have to do the following steps:

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.

Vijay.

[r_sonakiya]

Thanks VJ for that tip...it worked....

Ravi