1.查看数据库版本
SYS@jzh>select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

2.查看密码区分大小的参数
SYS@jzh>show parameter sec_case_sensitive

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE----------------默认为true
3.创建用户
SYS@jzh>create user jzh identified by JZH;------密码大写
User created.
SYS@jzh>grant connect,resource to jzh;
Grant succeeded.
4.小写密码偿试登陆数据库
SYS@jzh>conn jzh/jzh
ERROR:
ORA-01017: invalid username/password; logon denied-----------登陆失败
Warning: You are no longer connected to ORACLE.
5.使用大写登陆数据库
@>conn jzh/JZH
Connected.
JZH@jzh>

总结：从11gR2开始，Oracle数据库开始区分用户密码大小，而且parameter sec_case_sensitive参数默认开启。

ITPub博客

Oracle 11gR2密码区分大小写

最新文章