From oracle 11g password can be case sensitive by setting
SEC_CASE_SENSITIVE_LOGON = true in initialization parameter file.
SQL> show parameter SEC_CASE_SENSITIVE_LOGON
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
Lets check the feature,
[oracle@configsrv1 ~]$ sqlplus / as sysdba
SQL> create user soumya identified by das;
User created.
SQL> grant connect to soumya;
Grant succeeded.
[oracle@configsrv1 ~]$ sqlplus / as sysdba
SQL> conn soumya/das
Connected.
Now we will check by providing the password in caps letter.
SQL> conn soumya/DAS
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
We can disable this feature by setting the parameter value to false.
SQL> alter system set SEC_CASE_SENSITIVE_LOGON= false scope=both;
System altered.
SQL> conn soumya/DAS
Connected.
No comments:
Post a Comment