[MEGA] ORACLE 帳號密碼過期

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; select username,account_status from dba_users; username account_status MGMT_VIEW OPEN SYS OPEN SYSTEM OPEN HNCBPG OPEN CRM OPEN BAT OPEN DBSNMP EXPIRED SYSMAN EXPIRED OUTLN EXPIRED & LOCKED FLOWS_FILES EXPIRED & LOCKED MDSYS EXPIRED & LOCKED ORDSYS EXPIRED & LOCKED EXFSYS EXPIRED & LOCKED WMSYS EXPIRED & LOCKED user bat -->帳號 by bat --> 密碼 alter user bat identified by bat;