sec_case_sensitive_logon - > This initialisation(init) parameter enables or disabled password case sensitivity in the database.
when sec_case_sensitive_logon is TRUE - -> t he database use login passwords are case sensitive.
when sec_case_sensitive_logon is FALSE - -> means database use login passwords are case insensitive.
DEFAULT VALUE IS TRUE .
Lets see below DEMO:
DEMO:
1. When sec_case_sensitive_logon is TRUE.
SQL> show parameter sec_case
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
SQL> alter user EXATREE identified by DBAclass;
User altered.
SQL> connect EXATREE/exatree
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> connect EXATREE/DBAclass
Connected.
We can see the the password is case sensitive.
2. When sec_case_sensitive_logon is FALSE.
Lets make the parameter to false:
SQL> ALTER SYSTEM SET sec_case_sensitive_logon=FALSE scope=both;
database altered.
SQL> show parameter sec_case
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE
SQL> alter user EXATREE identified by DBAclass;
User altered.
Now try to connect with any case(small or caps)
SQL>
SQL> connect EXATREE/exatree
Connected.
SQL> connect EXATREE/EXATREE
Connected.
We can see password is case insensitive.
init parameter DATABASEDatabase-Wiki