Oracle User Password 기간 무제한 설정

1. 확인

SQL> SELECT * FROM DBA_PROFILES   2  WHERE PROFILE='DEFAULT'; PROFILE                        RESOURCE_NAME                    RESOURCE          LIMIT ---------------- ----------------------------------- ---------------    ---------------- DEFAULT                        COMPOSITE_LIMIT                      KERNEL       UNLIMITED DEFAULT                        SESSIONS_PER_USER                 KERNEL       UNLIMITED DEFAULT                        CPU_PER_SESSION                     KERNEL       UNLIMITED DEFAULT                        CPU_PER_CALL                          KERNEL       UNLIMITED DEFAULT                        LOGICAL_READS_PER_SESSION  KERNEL       UNLIMITED DEFAULT                        LOGICAL_READS_PER_CALL       KERNEL       UNLIMITED DEFAULT                        IDLE_TIME                                 KERNEL       UNLIMITED DEFAULT                        CONNECT_TIME                         KERNEL       UNLIMITED DEFAULT                        PRIVATE_SGA                            KERNEL       UNLIMITED DEFAULT                        FAILED_LOGIN_ATTEMPTS          PASSWORD       10 DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD       180 PROFILE                        RESOURCE_NAME                      RESOURCE         LIMIT -------- ------- ------------------------------------ ---------------- ----------------- DEFAULT                        PASSWORD_REUSE_TIME            PASSWORD     UNLIMITED DEFAULT                        PASSWORD_REUSE_MAX            PASSWORD     UNLIMITED DEFAULT                        PASSWORD_VERIFY_FUNCTION   PASSWORD     NULL DEFAULT                        PASSWORD_LOCK_TIME             PASSWORD     1 DEFAULT                        PASSWORD_GRACE_TIME           PASSWORD      7 16 rows selected. SQL>

 

2. 변경 

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; Profile altered. SQL> SELECT * FROM DBA_PROFILES   2  WHERE PROFILE='DEFAULT'; PROFILE                        RESOURCE_NAME                    RESOURCE          LIMIT ---------------- ----------------------------------- ---------------    ---------------- DEFAULT                        COMPOSITE_LIMIT                      KERNEL        UNLIMITED DEFAULT                        SESSIONS_PER_USER                 KERNEL        UNLIMITED DEFAULT                        CPU_PER_SESSION                     KERNEL        UNLIMITED DEFAULT                        CPU_PER_CALL                          KERNEL        UNLIMITED DEFAULT                        LOGICAL_READS_PER_SESSION  KERNEL        UNLIMITED DEFAULT                        LOGICAL_READS_PER_CALL       KERNEL        UNLIMITED DEFAULT                        IDLE_TIME                                 KERNEL        UNLIMITED DEFAULT                        CONNECT_TIME                         KERNEL        UNLIMITED DEFAULT                        PRIVATE_SGA                            KERNEL        UNLIMITED DEFAULT                        FAILED_LOGIN_ATTEMPTS          PASSWORD       10 DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD    UNLIMITED PROFILE                        RESOURCE_NAME                      RESOURCE         LIMIT -------- ------- ------------------------------------ ---------------- ----------------- DEFAULT                        PASSWORD_REUSE_TIME            PASSWORD     UNLIMITED DEFAULT                        PASSWORD_REUSE_MAX            PASSWORD     UNLIMITED DEFAULT                        PASSWORD_VERIFY_FUNCTION   PASSWORD     NULL DEFAULT                        PASSWORD_LOCK_TIME             PASSWORD     1 DEFAULT                        PASSWORD_GRACE_TIME           PASSWORD      7 16 rows selected.