9i, 10g까지는 대소문자 구분이 없었지만 11g부터는 대소문자 구분을 하게 된다.

 주로 로그인시 대소문자 구분을 위해서 사용된다.

SQL> show parameter sen

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE  << 대소문자사용중(default)
SQL>
SQL>
SQL> alter system set sec_case_sensitive_logon=FALSE;  << 대소문자사용안함 설정

System altered.

SQL> show parameter sen

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     FALSE << 설정완료


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  313860096 bytes
Fixed Size                  1344652 bytes
Variable Size             281021300 bytes
Database Buffers           25165824 bytes
Redo Buffers                6328320 bytes
Database mounted.
Database opened.
SQL> show parameter sen

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     FALSE
SQL>

 

SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /oracle/app/oracle/product/11.
                                                 2.0/dbs/spfileLINUXORCL.ora
SQL> 

 

- Dos 공격으로부터의 보호

  SEC_PROTOCOL_ERROR_FURTHER_ACTION = CONTINUE (Default)

  SEC_PROTOCOL_ERROR_TRACE_ACTION=NONE,TRACE(Default),LOG,ALERT (모니터링 지정)

 

- Brute Force 공격으로부터의 보호

  SEC_MAX_FAILED_LOGIN_ATTEMPTS = 1 - (Default)

Posted by Any DB
,