Oracle/MySQL 관련 게시판

2018/04/22(20:26) from 211.209.26.174
작성자 : 주인장 조회수 : 4562 , 줄수 : 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.

Modify Delete Post Reply Backward Forward List
Powered by Kang Jul Ki