前端之家收集整理的这篇文章主要介绍了
Oracle 12c的用户密码默认是区分大小写的,
前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
- [oracle@db12cr2 bin]$ sqlplus / as sysdba
-
- sql*Plus: Release 12.2.0.1.0 Production on Wed Mar 15 05:39:28 2017
-
- Copyright (c) 1982,2016,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 TRUE ----------->>>参数值是TRUE,默认值就是TRUE.
-
- sql> create user c##test identified by db12c;
-
- User created.
-
- sql> grant create session to c##test;
-
- Grant succeeded.
-
- sql> conn c##test/db12c ------>>>注意是小写的c
- Connected.
- sql> conn c##test/db12C ------>>>注意是大写的C
- ERROR:
- ORA-01017: invalid username/password; logon denied ----------->>>这意味着12c默认就是区分大小写的.
-
-
- Warning: You are no longer connected to ORACLE.
- sql>