Oracle Database has a parameter that you can define case sensitivity on users’s logon. This parameter is called SEC_CASE_SENSITIVE_LOGON and has default setting to TRUE (enabling case sensitivity). Then, follow an example using this parameter:
SQL> conn /as sysdba
Connected.
SQL>show parameters sec_case
NAME TYPE VALUE
——————————- ———- ————————-
sec_case_sensitive_logon boolean TRUE
SQL> create user brunors identified by techdatabasket;
User created.
SQL> grant connect, resource, create session to brunors;
Grant succeeded.
- SEC_CASE_SENSITIVE_LOGON = TRUE:
SQL> conn brunors/techdatabasket
Connected.
SQL> show user
USER is “BRUNORS”
SQL> conn brunors/TECHDATABASKET
ERROR:
ORA-01017: invalid username/password; logon denied
- SEC_CASE_SENSITIVE_LOGON = FALSE:
SQL> alter system set sec_case_sensitive_logon=FALSE scope=both;
System altered.
SQL> show parameters sensitive
NAME TYPE VALUE
———————————— ———– ——————————
sec_case_sensitive_logon boolean FALSE
SQL> conn brunors/TECHDATABASKET
Connected.
SQL> show user
USER is “BRUNORS”
SQL> conn brunors/techdatabasket
Connected.
SQL> show user
USER is “BRUNORS”
I hope this post can help you!
