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 ';
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
alter user name identified by values 'encrypted password saved before;
that is:
alter user GGSUSER1 identified by values 'F2BF19BAEAE0917E ';
No comments:
Post a Comment