OraFAQ Forum: Server Administration » how to restore the old password

Home » RDBMS Server » Server Administration » how to restore the old password

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to restore the old password [message #57389]

Wed, 11 June 2003 00:24

ramesh
Messages: 123
Registered: August 2000

Senior Member

hi,
i want to change a user password. after changing, and sometime later, i want to restore the old password, which i doesnt know. but i have stored the password info from dba_users;

Can any one help me in this regard

All the replies r most welcome.

Report message to a moderator

Re: how to restore the old password [message #57390 is a reply to message #57389]

Wed, 11 June 2003 02:17

Maaher
Messages: 7065
Registered: December 2001

Senior Member

1.SELECT password
  FROM dba_users
 WHERE username = the_user;

2. Save the result string ( e.g. 'F9CB6DE092F00093') somewhere you can find it back.

3.ALTER USER the_user IDENTIFIED BY new_password;<PRE>
4. connect as the_user using new_password and perform whatever you like as the_user.
5. to set it back: <PRE>ALTER USER the_user IDENTIFIED BY <B>VALUES 'F9CB6DE092F00093'</B>;

where the value between the quotes is the value you originally found in the password column of dba_users.

MHE

Report message to a moderator

Re: how to restore the old password [message #57401 is a reply to message #57390]

Thu, 12 June 2003 03:45

ramesh
Messages: 123
Registered: August 2000

Senior Member

hi maheer,
thanks for the reply.
i know the procedure. but i forgot the "values" parameter.i couldnt recollect it. Anyway, i got it from u. Thanks for ur kind reply in helping me.

bye

Report message to a moderator

Previous Topic:	problem with MTS
Next Topic:	Unable to physically remove EXAMPLE dataf ile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:38:09 CDT 2024