11g用户口令区分大小写

大家知道，在11g以前的版本中，用户的口令是不分大小写的，如下所示：

[oracle1@db1 oracle1]$ sqlplus dyx/dyx

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 19 11:12:50 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>

[oracle1@db1 oracle1]$ sqlplus dyx/DYx

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 19 11:13:00 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>

在11g中有个初始参数可以供用户控制口令用不用区分大小写，该参数为：

sec_case_sensitive_logon＝true       区分大小写  (default)
sec_case_sensitive_logon＝false       不区分大小写

SQL> show parameter sec_case_sensitive_logon

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE

[oracle@test db_1]$ sqlplus lzdyxin/lzdyxin

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Sep 19 12:49:59 2008
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

[oracle@test db_1]$ sqlplus lzdyxin/LZDYXIN

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Sep 19 12:50:12 2008
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied

修改sec_case_sensitive_logon＝false
SQL> alter system set sec_case_sensitive_logon=false scope=both;

System altered.
SQL>

再次用大小写混全或大写的口令登录

[oracle@test db_1]$ sqlplus lzdyxin/LZDyxIN

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Sep 19 13:10:33 2008
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

 

----完------