문제
접속 후
오류발생
ORA-28001: the password has expired within 7 days
해결
-- 새로운 패스워드 설정
sys나 system 계정 접속 후
ALTER USER useer_id IDENTIFIED BY new_password;
-- 1) DBA_USERS 확인
SELECT *
FROM DBA_USERS
WHERE USERNAME = 'JAVAJSP';
결과>
USERNAME ACCOUNT_STATUS EXPIRY_DATE
JAVAJSP EXPIRED 2021-03-26
-- 2) DBA_PROFILES 확인
SELECT *
FROM DBA_PROFILES
WHERE PROFILE = 'DEFAULT'
AND RESOURCE_NAME = 'PASSWORD_LIFE_TIME';
결과>
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
-- 3) 새로운 패스워드 설정
ALTER USER JAVAJSP IDENTIFIED BY javajsp;
-- 4) DBA_USERS 확인
SELECT *
FROM DBA_USERS
WHERE USERNAME = 'JAVAJSP';
결과>
USERNAME ACCOUNT_STATUS EXPIRY_DATE
JAVAJSP OPEN 2021-09-25
참고
Database SQL Reference
docs.oracle.com/cd/B19306_01/server.102/b14200/statements_2007.htm
Changing Password Lifetime and Grace Period:
Example The following statement modifies the profile app_user2 PASSWORD_LIFE_TIME to 90 days and PASSWORD_GRACE_TIME to 5 days:
ALTER PROFILE app_user2 LIMIT PASSWORD_LIFE_TIME 90 PASSWORD_GRACE_TIME 5;
새로운 글 - 추가 내용 포함