Enable and disable Case Sensitive password in Oracle

Enable and disable Case Sensitive password in Oracle

For case sensitive password in Oracle database, we need to set the parameter “sec_case_sensitive_logon”.
This parameter is dynamic we are not need to restart the database after changing its value.
Note: This parameter is depreciated in 12.2 version of Oracle and set as TRUE value if you change it to false user not able to connect. So, keep it value to TRUE.

SQL> show parameter sec_case_sensitive_logon

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


Note: Default value is TRUE.

Disable the Case Sensitive Password in Oracle

ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON=FALSE SCOPE=BOTH;

Enable the Case Sensitive Password in Oracle

ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON=TRUE SCOPE=BOTH;

Note:
During creating of new password file you can use ORAPWD command with IGNORECASE=Y for handling case sensitivity in password.

Example

SQL> alter system set sec_case_sensitive_logon=TRUE scope=both;

System altered.


SQL> conn c##test/test
Connected.
SQL> conn c##test/Test
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.