oracle 11g新特性之：密码区分大小写

默认情况下，11g增加了密码区分大小写的新特性，如下：
SQL> create user lcz identified by lcz;       

User created.

SQL> grant connect,resource to lcz;

Grant succeeded.

SQL> conn lcz/LCZ
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.

SQL>
SQL> conn lcz/lcz
Connected.
SQL>

也可以通过修改初始化参数sec_case_sensitive_logon=false，将该功能关闭：
SQL> alter system set sec_case_sensitive_logon = false;

System altered.

SQL>
SQL>
SQL>  conn lcz/LCZ
Connected.

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

转载于:http://blog.itpub.net/12355989/viewspace-713940/