Temporarily Change Oracle Password

Example to Change SYS password Temporarily

* Login database box.
* Login SQL*Plus as sysdba

sqlplus / AS sysdba

* Find password hash value for SYS

SQL> SELECT name,password FROM sys.user$ WHERE name='SYS';
 
NAME                           PASSWORD
------------------------------ ------------------------------
SYS                            795C72B03B3ED770

* Change password

SQL> ALTER USER sys IDENTIFIED BY tempsyspass;

* Do whatever.
* Change password back to the old hash value:

SQL> ALTER USER sys IDENTIFIED BY VALUES '795C72B03B3ED770';

References

* Fact sheet about Oracle database passwords

This entry was posted in oracle. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *


*

This site uses Akismet to reduce spam. Learn how your comment data is processed.