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> 

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!