SEC_CASE_SENSITIVE_LOGON 参数

来源：互联网发布：更换断桥铝门窗知乎编辑：程序博客网时间：2024/05/17 07:53

beginning with Oracle Database 11g Release 1, database passwordsare case-sensitive. (You can
disable case sensitivity and return to pre–Release 11g behavior by setting the SEC_CASE_SENSITIVE_LOGON initialization parameter to FALSE.)
从11.1开始，数据库的密码开始区分大小写，但是可以同更改SEC_CASE_SENSITIVE_LOGONinitialization=false 回归到以前的状态。
在11.2 默认是true
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> show parameter SEC_CASE_SENSITIVE_LOGON

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

SEC_CASE_SENSITIVE_LOGON&nbsp;参数

SEC_CASE_SENSITIVE_LOGON 参数