Oracle Database Discussions

actually it will take long time to decrypt it


if you have sys admin password change the password using

alter user HR identified by <your new password>

you can change the password of hr

alter user hr identified by new_password;

you cannot decrypt the hr password.

Default password for HR will be HR.
If there is application configured for that HR schema then just don't change the HR password from database end, if you do so the application might not work. There will be a procedure to change the password at database end if it is also encoded in the application somewhere for connectivity. It should be changed in both database and application side.

But if I am not over exhagerating and if this is just a test system and HR is not used in any frontend application then just change it with 'alter user HR identified by <new password here>; statement. And moreover you cannot decrypt passwords just like that.

Ok I understand, but is it impossible decrypt password?
Don't have any chance ?

Thanks

No.

Hello,

In fact the password stored in Oracle Database is not only Encrypted but Hashed by an internal algorithm.

So, there's no way to decrypt it.

Else, you may find on Google some tools to "crack" passwords but, most of them use a Dictionary. So if you set a strong password these tools won't be very efficient.

You'll have much more informations (and tools) from the famous site of Pete Finnigan:

http://www.petefinnigan.com/


Hope this help.
Best regards,
Jean-Valentin

Database uses DAS, RSA, AES, etc complex algorithm to encrypt the passwords, so its not possible to decrypt it.

But I suspect that you are planning to do some hacking.

for your information
but dont misuse it .. you can alter the user password and again you can reset the old password using old hash value.

SQL> create user test identified by test;

User created.

SQL> grant connect,resource to test;

Grant succeeded.

SQL> select username,password from dba_users where username='TEST';

USERNAME                       PASSWORD
------------------------------ ------------------------------
TEST                           7A0F2B316C212D67

SQL> conn test/test;
Connected.
SQL> conn sys/oracle as sysdba;
Connected.
SQL> alter user test identified by newpwd;

User altered.

SQL> conn test/test;
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> conn test/newpwd;
Connected.
SQL> show user
USER is "TEST"
SQL> conn sys/oracle as sysdba;
Connected.

SQL> alter user test identified by values  '7A0F2B316C212D67';

User altered.

SQL> conn test/newpwd;
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> conn test/test;
Connected.
SQL> show user;
USER is "TEST"
SQL>

Thanks everyone for helping.
Sir I don't want to hack.


Best regards,
Rufatet Babakishiev