Home » RDBMS Server » Server Administration » Recovering a lost schema password
Recovering a lost schema password [message #265143] Wed, 05 September 2007 09:32 Go to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
Friends,
This is NOT urgent, so answer it when your having nothing better to do! We have one schema whose password is not known. I can not reset it as it is stored somewhere in application. Is there any way to find out what that password was?

Thanks,
Nirav

[Updated on: Wed, 05 September 2007 12:48] by Moderator

Report message to a moderator

Re: Recovering a lost schema password [message #265150 is a reply to message #265143] Wed, 05 September 2007 09:55 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
No if password is stored in data dictionary.

Yes if password is stored in your application.



Or you can reset your schema password by this command


alter user my_forgot_schema identified by unforgetable_schema;
Re: Recovering a lost schema password [message #265248 is a reply to message #265143] Wed, 05 September 2007 22:16 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
I can not reset it as it is stored somewhere in application


What do you mean by it?

If the password is in application then from application see it and then reset it in your database.
Previous Topic: difference between Database character set & National Character Set..?
Next Topic: Options of starting oracle.........
Goto Forum:
  


Current Time: Mon Dec 02 07:59:16 CST 2024