Home » SQL & PL/SQL » SQL & PL/SQL » user password (Find an user password)
user password [message #272996] Mon, 08 October 2007 09:24 Go to next message
jeannezhang
Messages: 21
Registered: May 2005
Junior Member
I am a Oracle database developer but I have a DBA question to consult experts.
We have an user which created long time ago. Now I need to know the password for this user. But nobody knows what the password is. Is any way can find the password from database?
Thanks.
Jeanne
Re: user password [message #272997 is a reply to message #272996] Mon, 08 October 2007 09:25 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Is any way can find the password from database?
NO way
Re: user password [message #272998 is a reply to message #272996] Mon, 08 October 2007 09:28 Go to previous messageGo to next message
jeannezhang
Messages: 21
Registered: May 2005
Junior Member
The only way to solve the problem is re-create the password, right?
Thanks.
Re: user password [message #272999 is a reply to message #272996] Mon, 08 October 2007 09:31 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
ALTER USER <old_username> IDENTIFIED BY <new_password>

but it will break process still using original password.
Re: user password [message #273000 is a reply to message #272996] Mon, 08 October 2007 09:40 Go to previous message
jeannezhang
Messages: 21
Registered: May 2005
Junior Member
Thanks. Since no way to get it. We have to create a new one.
Previous Topic: ANALYZE INDEX
Next Topic: View created different between instances
Goto Forum:
  


Current Time: Sat Dec 10 22:38:59 CST 2016

Total time taken to generate the page: 0.03850 seconds