帳號密碼過期處理方法

2014-02-10 18:05

ERROR: ORA-28002: the password will expire within 6 days

 

select username,account_status from dba_users;

 

ALTER PROFILE DeFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

 

alter user nagios identified by nagios123;