OraFAQ Forum: Security » How to operate a user's password and change it back

Home » RDBMS Server » Security » How to operate a user's password and change it back

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

How to operate a user's password and change it back [message #64498]

Wed, 02 February 2005 12:51

jack
Messages: 123
Registered: September 2000

Senior Member

We installed a software which designated a user. Unfortuantely I forget the user 's password. I want to do something as the user, then change the pasword back in case the application won't work. I have the sysdba privilige. Can someone help me out?

Thanks

Jack

Report message to a moderator

Re: How to operate a user's password and change it back [message #64502 is a reply to message #64498]

Wed, 02 February 2005 21:45

Frank
Messages: 7901
Registered: March 2000

Senior Member

Kindly ask the user if you can change his/her password. IMHO It is not done to masquerade your actions by becoming a subordinate user.

hth

Report message to a moderator

Re: How to operate a user's password and change it back [message #64505 is a reply to message #64498]

Thu, 03 February 2005 01:29

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Here's how (thanks to T.Kyte):

How to become another User in SQLPlus

As Frank stated, be careful that this kind of script doesn't get abused.

MHE

Report message to a moderator

Re: How to operate a user's password and change it back [message #64514 is a reply to message #64505]

Thu, 03 February 2005 04:43

jack
Messages: 123
Registered: September 2000

Senior Member

Thanks guys. I have got the answer. I can understand your worrying that we are not supposed to change another user's password. My situation is that the pre-DBA has gone. He left nothing for me. I have to pick up the left off work. In order to continue the old task and without password, I have to find ways to by pass.

Jack

Report message to a moderator

Previous Topic:	username, password, host string(PL/SQL) of oracle 10g developer suite
Next Topic:	Modifying User Profile to lock him after 3 attempts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 09:43:20 CDT 2025