oracle 11g username password 增强对大小写敏感

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:39

oracle 11g username password 增强对大小写敏感

在11g 以前的版本中 用户名的密码对大小写是不敏感的
10G:
[oracle@asm ~]$ sqlplus paul/paul
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 22 16:19:01 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>
[oracle@asm ~]$ sqlplus paul/PAUL
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 22 16:19:13 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:
[oracle@asm11g ~]$ sqlplus paul/paul
SQL*Plus: Release 11.1.0.6.0 - Production on Mon Jul 21 04:50:46 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> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@asm11g ~]$ sqlplus paul/PAUL
SQL*Plus: Release 11.1.0.6.0 - Production on Mon Jul 21 04:50:49 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
这个新特性是在dbca创建数据库默认就会选上的
http://space.itpub.net/batch.download.php?aid=6848][img=297,112]http://space.itpub.net/attachments/2008/07/7199859_200807221738271.thumb.jpg[/img]
keep the enhanced 11g default security setting (recommended)
可以通过 [font=新宋体]SEC_CASE_SENSITIVE_LOGON 初始化参数来关闭这个特性
默认值为true
SQL> show parameter sec_case_sensitive_logon
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
sec_case_sensitive_logon boolean
TRUE
关掉这个参数 对大小写就不敏感了
SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;
System altered.
SQL> show parameter sec_case_sensitive_logon
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
sec_case_sensitive_logon boolean
FALSE

[oracle@asm11g ~]$ sqlplus paul/PAUL
SQL*Plus: Release 11.1.0.6.0 - Production on Mon Jul 21 04:59:12 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>

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】