Warning: session_start(): open(/tmp/sess_bi7hrachmimuj6qq1qa6stqs86, O_RDWR) failed: No space left on device (28) in /razi/eraazi/darbari/mercy/index.php on line 15
EraAzi | sec_case_sensitive_logon parameter in oracle sec_case_sensitive_logon parameter in oracle
 

         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