Oracle 12.2 sec_case_sensitive_logon设置为true 或者false 时,
发布时间:2020-12-12 15:15:04 所属栏目:百科 来源:网络整理
导读:首先测试system用户: [oracle@db12cr2 bin]$ sqlplus system/aaaaaaSQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 15 06:43:38 2017Copyright (c) 1982,2016,Oracle. All rights reserved.Last Successful login time: Mon Mar 13 2017 18:21:44 +08:0
首先测试system用户:
[oracle@db12cr2 bin]$ sqlplus system/aaaaaa SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 15 06:43:38 2017 Copyright (c) 1982,2016,Oracle. All rights reserved. Last Successful login time: Mon Mar 13 2017 18:21:44 +08:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> show parameter case NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sec_case_sensitive_logon boolean TRUE ------------->>>>>>>>>>>>>默认值 SQL> SQL> SQL> alter system set sec_case_sensitive_logon=false;------------->>>>>>>>>>>>>改为false System altered. SQL> show parameter case NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sec_case_sensitive_logon boolean FALSE SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production [oracle@db12cr2 bin]$ sqlplus system/aaaaaa ------------->>>>>>>>>>>>>然后用正确的密码就不能登录了. SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 15 06:44:19 2017 Copyright (c) 1982,Oracle. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied Enter user-name: ^C [oracle@db12cr2 bin]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 15 06:44:43 2017 Copyright (c) 1982,Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> show parameter case NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sec_case_sensitive_logon boolean FALSE SQL> alter system set sec_case_sensitive_logon=true;------------->>>>>>>>>>>>>改为true System altered. SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production [oracle@db12cr2 bin]$ sqlplus system/aaaaaa ------------->>>>>>>>>>>>>然后用正确的密码就能登录了!!!! SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 15 06:45:17 2017 Copyright (c) 1982,Oracle. All rights reserved. Last Successful login time: Wed Mar 15 2017 06:43:39 +08:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> 再来测试C##test用户: SQL> alter system set sec_case_sensitive_logon=false; System altered. SQL> conn c##test/db12c Connected. SQL> show user USER is "C##TEST" SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production [oracle@db12cr2 bin]$ sqlplus c##test/db12c------>>>小写的C,能登陆成功. SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 15 06:35:34 2017 Copyright (c) 1982,Oracle. All rights reserved. Last Successful login time: Wed Mar 15 2017 06:35:08 +08:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production [oracle@db12cr2 bin]$ sqlplus c##test/db12C------>>>大写的C,能登陆成功,说明密码不再区分大小写. SQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 15 06:35:54 2017 Copyright (c) 1982,Oracle. All rights reserved. Last Successful login time: Wed Mar 15 2017 06:35:34 +08:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> show user USER is "C##TEST" SQL> ----->>>>>C##test用户能用密码登录成功... (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |