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>Comments
Tags: Change Values Of Decrypt Password by SQL, Decrypt Password, Decrypt Password by SQL, Oracle Query