Wednesday, August 8, 2018

Oracle 12c Expired User


-- How to reset the Expired user to Open with same password

select 'alter user ' || su.name || ' identified by values'    || ' ''' || spare4 || ';'    || su.password || ''';'
from sys.user$ su
join dba_users du on ACCOUNT_STATUS like 'EXPIRED%' and su.name = du.username;


-- Set Oracle Profile as Password Unlimited and Failed Login Unlimited

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED;