-- disable JDE password expire
alter profile DEFAULT limit password_life_time UNLIMITED;
alter profile DEFAULT limit password_grace_time UNLIMITED;
select resource_name,limit from dba_profiles where profile='DEFAULT';
---
spool /tmp/userUnLock.log
select username,account_status,to_char(EXPIRY_DATE, 'yyyy-mm-dd')Expire from dba_users;
alter user PS910DTA identified by PS910DTA;
alter user PS910CTL identified by PS910CTL;
alter user PS910 identified by PS910;
alter user TESTDTA identified by TESTDTA;
alter user TESTCTL identified by TESTCTL;
alter user DV910 identified by DV910;
alter user CRPDTA identified by CRPDTA;
alter user CRPCTL identified by CRPCTL;
alter user PY910 identified by PY910;
alter user PRODDTA identified by PRODDTA;
alter user PRODCTL identified by PRODCTL;
alter user PD910 identified by PD910;
alter user DD910 identified by DD910;
alter user OL910 identified by OL910;
alter user SVM910 identified by SVM910;
alter user SY910 identified by SY910;
alter user PRODUSER identified by PRODUSER;
alter user DEVUSER identified by DEVUSER;
alter user APPLEAD identified by APPLEAD;
alter user JDEDBA identified by JDEDBA;
alter user JDE identified by JDE;
alter user OVR_BIPLATFORM identified by ovsadminE1;
alter user OVR_MDS identified by ovsadminE1;
select username,account_status,to_char(EXPIRY_DATE, 'yyyy-mm-dd')Expire from dba_users;
spool off;
exit;
