change Oracle user account status from EXPIRE to OPEN

Hello,

Any way to change the Oracle user account status from expire  to open without resetting the password?

Solutions:

select spare4 from sys.user$ where name='[user name]';
select password from dba_users where username = '[user name]';

then :

Then use this to reset it:

alter user [user name] identified by values '[result from above query]

Example:

select spare4 from sys.user$ where name='ERMANKARA';
select password from dba_users where username = 'ERMANKARA';

Output:

SPARE4
--------------------------------------------------------------------------------
S:B230301384B541273C862E49A5C784B21B14AFF40920DDC6D364C4514F89
1 row selected.
alter user ERMANKARA identified by values 'S:B230301384B541273C862E49A5C784B21B14AFF40920DDC6D364C4514F89';

Have a good day.

Hits: 6

Leave a Reply

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