1. SYSTEM 계정으로 접속

2. – DBA 유저들 확인 – select username, account_status, expiry_date, profile from dba_users;

– Expire Date 확인 –

1. select * from dba_profiles where profile = ‘DEFAULT’

2. – Unlimited 변경 – alter profile default limit password_life_time unlimited;

3. – 비밀번호 재변경 ALTER USER [User ID] IDENTIFIED BY [Password]; ALTER USER system IDENTIFIED BY tapaman;

4. – 변경 확인 – SELECT USERNAME, ACCOUNT_STATUS, LOCK_DATE, EXPIRY_DATE FROM DBA_USERS WHERE USERNAME = ‘TRENDUP20’ ORDER BY CREATED;