Oracle 12.2 sec_case_sensitive_logon设置为true 或者false 时,针对 system用户和新建用户的区别.
来源:互联网 发布:itouch4怎么下载软件 编辑:程序博客网 时间:2024/06/07 13:34
首先测试system用户:
再来测试C##test用户:
[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:00Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL> show parameter case NAME TYPE VALUE------------------------------------ ----------- ------------------------------sec_case_sensitive_logon boolean TRUE ------------->>>>>>>>>>>>>默认值SQL> SQL> SQL> alter system set sec_case_sensitive_logon=false;------------->>>>>>>>>>>>>改为falseSystem altered.SQL> show parameter case NAME TYPE VALUE------------------------------------ ----------- ------------------------------sec_case_sensitive_logon boolean FALSESQL> exitDisconnected 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 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.ERROR:ORA-01017: invalid username/password; logon deniedEnter user-name: ^C[oracle@db12cr2 bin]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 15 06:44:43 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL> show parameter caseNAME TYPE VALUE------------------------------------ ----------- ------------------------------sec_case_sensitive_logon boolean FALSESQL> alter system set sec_case_sensitive_logon=true;------------->>>>>>>>>>>>>改为trueSystem altered.SQL> exitDisconnected 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 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.Last Successful login time: Wed Mar 15 2017 06:43:39 +08:00Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL>
再来测试C##test用户:
SQL> alter system set sec_case_sensitive_logon=false; System altered.SQL> conn c##test/db12cConnected.SQL> show userUSER is "C##TEST"SQL> exitDisconnected 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 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.Last Successful login time: Wed Mar 15 2017 06:35:08 +08:00Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL> exitDisconnected 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 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.Last Successful login time: Wed Mar 15 2017 06:35:34 +08:00Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL> show userUSER is "C##TEST"SQL> ----->>>>>C##test用户能用密码登录成功...
0 0
- Oracle 12.2 sec_case_sensitive_logon设置为true 或者false 时,针对 system用户和新建用户的区别.
- setOnTouchEvent 设置返回值为true 和 false的区别
- setOnTouchEvent 设置返回值为true 和 false的区别
- setOnTouchEvent 设置返回值为true 和 false的区别
- oracle中sys用户和system用户的区别
- oracle中sys用户和system用户的区别
- oracle中sys用户和system用户的区别
- Oracle中sys用户和system用户的区别
- oracle中sys用户和system用户的区别
- Ajax请求中的async设置为false/true的区别
- [android] setOnTouchEvent 设置返回值为true 和 false的区别
- ORACLE SYS和SYSTEM用户区别
- Oracle数据库中sys和system两个用户的区别
- Oracle中sys和system两个用户的区别
- Oracle数据库中sys和system两个用户的区别
- django staticfiles DEBUG设置为True或者False的关键内幕
- django staticfiles DEBUG设置为True或者False的关键内幕
- django staticfiles DEBUG设置为True或者False的关键内幕
- 忘记apusic应用服务器web控制台admin密码怎么办?
- Messenger,Handler,IBinder是如何合作实现跨进程通信的
- 使用CSDN Markdown编辑器写博客
- HDU4722~Good Numbers(思路)
- Android ActionBar完全解析,使用官方推荐的最佳导航栏(上)
- Oracle 12.2 sec_case_sensitive_logon设置为true 或者false 时,针对 system用户和新建用户的区别.
- 关于数组元素的排列组合
- 最短路径相关求解方法
- hal层代码
- IPv6和高级网络协议
- C++抽象编程——递归简介(6)——相互递归与递归思想总结
- 傅里叶变换的Matlab代码
- git flow 工作流
- 计算机网络Introduction