ORA-28000 & ORA-28001

ORA-28000

col profile format a30
col username format a30
col account_status format a30

select username, account_status, profile, expiry_date from dba_users;

select username, account_status, profile, expiry_date from dba_users where username='&username';

alter user scott account unlock;

ORA-28001

alter user scott identified by scott;

查看过期时间

col profile format a30
col resource_name format a40
col resource_type format a30
col limit format a30
select * from dba_profiles;
select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

alter profile default limit password_life_time 360; --即时生效，unlimited