Become Another User
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Become Another User

  1. #1
    Join Date
    Jan 2001
    Posts
    61
    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

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    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.

  3. #3
    Join Date
    Jan 2001
    Posts
    61

    Thanks.....

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

    Ravi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width