Oracle RDBMS unexpire account

Let me preface this by saying you are doing this at your own risk!

So I have an Oracle SSO DB user whose account is locked.  SSO passwords are random and created when SSO is installed.  I can retrieve the password using the ldapsearch tool, then do an “alter user USERNAME identified by PASSWORD;” but that isn’t all that fun.

Instead, here is a slick way to unexpire an expired account with the original password (when you don’t know the original password):

select password, spare4 from sys.user$ where name='USERNAME';
PASSWORD    SPARE4
1FDF39535EDB8EDD    S:5BEFDD3B650E6910F42EAB51EBDFF612205E92620B56166AF480551F41B6

alter user USERNAME identified by values 'S:5BEFDD3B650E6910F42EAB51EBDFF612205E92620B56166AF480551F41B6;1FDF39535EDB8EDD';
notice the semicolon between SPARE4 and PASSWORD in the above statement.

This should unexpire the account using the current password.  You should probably check that the account is not also locked.

Advertisement