Tuesday, January 20, 2015

Changing Case Sensitive Password In Oracle 11g

SQL> show parameter sec_case_sensitive_logon;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE

SQL> alter system set sec_case_sensitive_logon=false scope=both;
System altered.

SQL> show parameter sec_case_sensitive_logon
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------

sec_case_sensitive_logon             boolean     FALSE

[Now you can enter the password with or without CAPS]

No comments:

Post a Comment