前端之家收集整理的这篇文章主要介绍了
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>