How to change the Oracle11g user password without case sensitivity
How to change the Oracle11g user password and not case-sensitive, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.
Connect to:
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
The system has changed.
SQL > show parameter sec_case_sensitive_logon
NAME TYPE VALUE
-
Connect to:
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
The system has changed.
SQL > show parameter sec_case_sensitive_logon
NAME TYPE VALUE
-
Sec_case_sensitive_logon boolean FALSE
SQL > boolean FALSE
When the parameter "sec_case_sensitive_logon" is false, 11g is not case-sensitive.
In contrast, 10g is case-insensitive.
Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.
