Oracle 12c的用户密码默认是区分大小写的

前端之家收集整理的这篇文章主要介绍了Oracle 12c的用户密码默认是区分大小写的前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
  1. [oracle@db12cr2 bin]$ sqlplus / as sysdba
  2.  
  3. sql*Plus: Release 12.2.0.1.0 Production on Wed Mar 15 05:39:28 2017
  4.  
  5. Copyright (c) 1982,2016,Oracle. All rights reserved.
  6.  
  7.  
  8. Connected to:
  9. Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
  10.  
  11. sql> show parameter case
  12.  
  13. NAME TYPE VALUE
  14. ------------------------------------ ----------- ----------
  15. sec_case_sensitive_logon boolean TRUE ----------->>>参数值是TRUE,默认值就是TRUE.
  16.  
  17. sql> create user c##test identified by db12c;
  18.  
  19. User created.
  20.  
  21. sql> grant create session to c##test;
  22.  
  23. Grant succeeded.
  24.  
  25. sql> conn c##test/db12c ------>>>注意是小写的c
  26. Connected.
  27. sql> conn c##test/db12C ------>>>注意是大写的C
  28. ERROR:
  29. ORA-01017: invalid username/password; logon denied ----------->>>这意味着12c默认就是区分大小写的.
  30.  
  31.  
  32. Warning: You are no longer connected to ORACLE.
  33. sql>

猜你在找的Oracle相关文章