Oracle Password Expired

17 sec read

SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;

Profile altered.

SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited;

Profile altered.

SQL> select username, account_status, EXPIRY_DATE from dba_users where username=’IRS’;

USERNAME ACCOUNT_STATUS EXPIRY_DA
—————————— ——————————– ———
IRS EXPIRED 25-JUN-20

SQL> ALTER USER IRS IDENTIFIED BY IRS041972;

User altered.

SQL> select username, account_status, EXPIRY_DATE from dba_users where username=’IRS’;

USERNAME ACCOUNT_STATUS EXPIRY_DA
—————————— ——————————– ———

Generate Insert Script

dadin
2 min read

Job not Running

dadin
18 sec read