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