Password

[krishnaindia2007]

I have forgotten password for a user and we are not using that username for last six months .
I tried using the following statement.

SELECT username,password
FROM dba_users;

But it is diplaying password as B320A8227BE47BDC
How to know the password?

[susarlasireesha]

U can not decrypt the password .but u can alter the password using
following command

ALTER USER IDENTIFIED BY ;
(IF u have required privileges)

[debasisdas]

If you could find the password directly by selecting from DBA_USERS then what is the use of oracle ?