oracle 11g 設定使用者密碼大小寫敏感

標籤：style   color   strong   io   for   2014   art   ar   

 11g通過一個參數設定密碼大小寫敏感，下面來做個實驗：

C:\Documents and Settings\guogang>sqlplus gg_test/[email protected]_gg

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 8月 4 17:54:19 2014
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
串連到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> show parameter  sec_case_sensitive_logon
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE


C:\Documents and Settings\guogang>sqlplus gg_test/[email protected]_gg
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 8月 4 17:54:06 2014
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
請輸入使用者名稱:


C:\Documents and Settings\guogang>sqlplus gg_test/[email protected]_gg
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 8月 4 17:52:35 2014
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
串連到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter system set sec_case_sensitive_logon=false;
系統已更改。

SQL> 從 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 斷開


C:\Documents and Settings\guogang>sqlplus gg_test/gg_tesT@10.10.15.25_gg
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 8月 4 17:53:48 2014
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
串連到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter  sec_case_sensitive_logon
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     FALSE