Example using sec_case_sensitive_logon to case sensitivity on Oracle Database

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:…