PDB접속했는데 ..
SQL> conn APP_USER/APP_USER@localhost:1521/pdborcl
ERROR:
ORA-28002: the password will expire within 7 days
SQL>
★ sysdba접속 후 아래 SQL로 확인
SELECT RESOURCE_NAME, LIMIT
FROM DBA_PROFILES
WHERE PROFILE = 'DEFAULT'
AND RESOURCE_TYPE = 'PASSWORD'
;
SQL> SELECT RESOURCE_NAME, LIMIT
2 FROM DBA_PROFILES
3 WHERE PROFILE = 'DEFAULT'
4 AND RESOURCE_TYPE = 'PASSWORD'
5 ;
RESOURCE_NAME LIMIT
-------------------------------- --------------------------------------------------------------------------------------------------
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 7
7 행이 선택되었습니다.
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
정책에 따라 기본 90일?이 적당 ^^;
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME 90;
★ PWD변경 방법은 아래처럼
SQL> ALTER USER APP_USER IDENTIFIED BY password
OR
SQL> ALTER USER APP_USER IDENTIFIED BY password REPLACE old_password;
[참고]sqlpatterns.wordpress.com/2015/11/23/replace-clause-for-changing-ones-password/