oracle11g怎么修改用户密码,修改Oracle11g用户密码不区分大小写 -电脑资料

连接到:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show 　parameter sec_case_sensitive_logon

NAME                                TYPE       VALUE

------------------------------------ ----------- ------------------------------

sec_case_sensitive_logon            boolean    TRUE

SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

系统已更改，修改Oracle11g用户密码不区分大小写》(https://www.unjs.com)。

SQL> show 　parameter sec_case_sensitive_logon

NAME                                TYPE       VALUE

------------------------------------ ----------- ------------------------------

sec_case_sensitive_logon            boolean    FALSE

SQL>

本文出自“技术新人”