Thursday, September 27, 2018

How to revert back to old password from new password oracle database

So the situation is I want to update the password but want to keep a backup to comeback to an old password.

So here are the steps to do that:
1. Select and save the value of the encrypted password. 

select * from sys.user$ where name like 'GGSUSER1';

or

select PASSWORD, NAME from sys.user$ where name like 'GGSUSER1';

PASSWORD                       NAME
------------------------------ ------------------------------
F2BF19BAEAE0917E               GGSUSER1

2. In case needed to revert back. Run the below command. 

alter user name identified by values 'encrypted password saved before;

that is:

alter user GGSUSER1 identified by values 'F2BF19BAEAE0917E ';
             

No comments:

Post a Comment