Change Oracle password temporarily

Change Oracle password temporarily

SQL> SELECT a.username, b.password FROM dba_users a, sys.user$ b WHERE a.username = 'AHMED' AND a.user_id = b.user#


USERNAME PASSWORD
-------- ----------------
AHMED 3KD55KGFST529KT5


SQL> alter user HRPAY identified by newpassword

After completing your work , now you can change the password back by using an undocumented feature called "by values"

SQL>alter user AHMED identified by values '3KD55KGFST529KT5';