| Oracle/MySQL 관련 게시판 |
|---|
| 2018/04/22(20:26) from 211.209.26.174 | |
| 작성자 : 주인장 | 조회수 : 2419 , 줄수 : 42 |
| [Oracle] 오라클 암호 변경 및 변경기간 무제한으로 설정 |
|---|
|
C:\Users\user>sqlplus "/as sysdba" SQL> select resource_name, limit from dba_profiles where profile='DEFAULT'; PASSWORD_LIFE_TIME 180 PASSWORD_GRACE_TIME 7 SQL> alter profile default limit password_life_time unlimited; Profile altered. SQL> select resource_name, limit from dba_profiles where profile='DEFAULT'; PASSWORD_LIFE_TIME UNLIMITED SQL> select username, account_status, lock_date, expiry_date from dba_users where username='SYSTEM'; USERNAME ------------------------------------------------------------ ACCOUNT_STATUS LOCK_DAT ---------------------------------------------------------------- -------- EXPIRY_D -------- SYSTEM EXPIRED 18/04/04 다음과 같이 암호를 변경한다 (system / oracle) SQL> alter user system identified by oracle; User altered. |
|
|