默认情况下,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.
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/