11G Example "SEC_CASE_SENSITIVE_LOGON" parameter

Let's me show using "SEC_CASE_SENSITIVE_LOGON" parameter.

Oracle 11G "SEC_CASE_SENSITIVE_LOGON" enable or disable password case sensitivity in the database.
Values:
true -> Database logon passwords are case sensitive.
false -> Database logon passwords are not case sensitive.

Example:
SQL> show parameter sec_case_sensitive_logon ;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE

SQL> conn surachart/password
Connected.

SQL> conn surachart/PASSWORD
ERROR:ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

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

SQL> conn surachart/password
Connected.

SQL> conn surachart/PASSWORD
Connected.

Anyway, You can find users who have case sensitive or case insensitive passwords by querying the DBA_USERS view. The PASSWORD_VERSIONS column in this view indicates the release in which the password was created. For example:

SQL> SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS;
USERNAME PASSWORD
------------------------------ --------
SYSTEM 10G 11G
SYS 10G 11G
MGMT_VIEW 10G 11G
SYSMAN 10G 11G
DBSNMP 10G 11G
SURACHART 10G 11G
DIP 10G 11G
OUTLN 10G 11G
WKSYS 10G 11G
OLAPSYS 11G
SI_INFORMTN_SCHEMA 10G 11G
------------------------------ --------