how to decrypt stored password in oracle

[shapam]

i want to knw that how to decrypt stored password in oracle database..

[pritaeas]

What password do you mean ? If you mean that from a user, then no, you can't (it's a hash).

[shapam]

PASSWORD USERNAME
------------------------------ ------------------------------
F894844C34402B67 SCOTT

that password i want to decrypt..

[pritaeas]

Where does that come from, did you insert that yourself (post your table structure and insert query), or is it an Oracle user (then see previous answer) ?

[shapam]

Where does that come from, did you insert that yourself (post your table structure and insert query), or is it an Oracle user (then see previous answer) ?

select username,password from dba_users where username='SCOTT';

this is the query that actual password stored in that dba_users master table..

[pritaeas]

Like I said before, you cannot decrypt that password because it is a hash.