技術(shù)分享 ORACLE 19C 實(shí)現(xiàn)不管大小寫
1.修改參數(shù)
alter system set sec_case_sensitive_logon=false;
2.修改SQLNET.ORA
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
3.修改一下用戶密碼
alter user lijie identified by lijiE;
4.無關(guān)大小寫
SQL> conn lijie/lijiE@192.168.133.121:1521/pdb1;
Connected.
SQL> conn lijie/lijie@192.168.133.121:1521/pdb1;
onnected.
標(biāo)簽：
