11G 新特性之 密码大小写敏感

11G开始数据库的密码默认是大小写敏感的，通过初始化参数 SEC_CASE_SENSITIVE_LOGON 控制的。

SQL> show parameter sec_case

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

同时创建密码文件的时候，也可以通过 ignorecase 进行设置

[oracle@localhost dbs]$ orapwd -help
Usage: orapwd file= entries= force= ignorecase= nosysdba=

  where
    file - name of password file (required),
    password - password for SYS will be prompted if not specified at command line,
    entries - maximum number of distinct DBA (optional),
    force - whether to overwrite existing file (optional),
    ignorecase - passwords are case-insensitive (optional),
    nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).
   
  There must be no spaces around the equal-to (=) character.
[oracle@localhost dbs]$

设置 sec_case_sensitive_logon 为 FALSE 。

SQL> alter system set sec_case_sensitive_logon=FALSE;

System altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost ~]$
[oracle@localhost ~]$ sqlplus maintain_user/maintain

SQL*Plus: Release 11.2.0.2.0 Production on Mon Nov 5 23:27:24 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost ~]$ sqlplus maintain_user/MAINTAIN

SQL*Plus: Release 11.2.0.2.0 Production on Mon Nov 5 23:27:36 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

SQL> alter system set sec_case_sensitive_logon=TRUE;

System altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost ~]$ sqlplus maintain_user/MAINTAIN

SQL*Plus: Release 11.2.0.2.0 Production on Mon Nov 5 23:28:09 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied

 

 

根据需要开启禁用该特性，建议开启加强密码的安全性。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25475140/viewspace-748408/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25475140/viewspace-748408/