OraFAQ Forum: Server Administration » how to get password for database users.

Home » RDBMS Server » Server Administration » how to get password for database users. (ORACLE 10g R2 (10.2.0.1.0))

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

how to get password for database users. [message #483660]

Wed, 24 November 2010 00:34

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Hi All,

Can anyone help me to get the actual password for the database users. If we talk about the dba_users account we have password in the encrypted form how to decrypt them and get actual password.

any jar file or any tool??

Thanks & Regards
Deepak. Smile

Report message to a moderator

Re: how to get password for database users. [message #483662 is a reply to message #483660]

Wed, 24 November 2010 00:37

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can't.
The password is not encrypted, it is hashed.
This means this is a one-way algorithm, no return possible.

Regards
Michel

Report message to a moderator

Re: how to get password for database users. [message #483665 is a reply to message #483662]

Wed, 24 November 2010 00:58

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Thanks for the Reply Sir, I have some application users which are created from the application itself and their passwords are stored in the encrypted form in the database not in the dba_users table but in some other table, So I was just wondering if I can get the actual password from the stored encrypted values.

The file that is used to encrypt the password is an encrypt.jar file.

Regards
Deepak

[Updated on: Wed, 24 November 2010 01:00]

Report message to a moderator

Re: how to get password for database users. [message #483666 is a reply to message #483662]

Wed, 24 November 2010 01:03

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

But Your DBA Can login to any user So ask him

Sriram

Report message to a moderator

Re: how to get password for database users. [message #483667 is a reply to message #483666]

Wed, 24 November 2010 01:04

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

This is no where related to your first question

If it is not hashed,then decrypt that using any of the decryption methods available.

sriram

[Updated on: Wed, 24 November 2010 01:07]

Report message to a moderator

Re: how to get password for database users. [message #483668 is a reply to message #483667]

Wed, 24 November 2010 01:17

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

I was not aware that passwords in the dba_users are hashed I thought they are in the encrypted form so thats why I was confused. Hope now clear with you Sir (sriram).

Regards
Deepak

Report message to a moderator

Re: how to get password for database users. [message #483669 is a reply to message #483668]

Wed, 24 November 2010 01:17

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Thanks everyone for your replies.

Regards
Deepak

Report message to a moderator

Previous Topic:	Apply oracle patch 10.2.0.5
Next Topic:	Tablespace issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 10:48:59 CDT 2024