sorry to disappoint you but ..
Code:SQL> create user test2 identified by test2; User created. SQL> grant create session to test2; Grant succeeded. SQL> select password from dba_users where username = 'TEST2'; PASSWORD ------------------------------ 2E3197EF1322CB1D SQL> alter user test2 identified by test5; User altered. SQL> connect test2/test5 Connected. SQL> connect / as sysdba Connected. SQL> alter user test2 identified by values '2E3197EF1322CB1D'; User altered. SQL> connect test2/test2 Connected. SQL> connect / as sysdba Connected. SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production PL/SQL Release 9.2.0.5.0 - Production CORE 9.2.0.6.0 Production TNS for Linux: Version 9.2.0.5.0 - Production NLSRTL Version 9.2.0.5.0 - Production




Reply With Quote