Thursday, March 13, 2014

Oracle: Disable Password Case Sensitive Option

To Remove Password Case Sensitive option in Oracle,

1) Check the current value of "SEC_CASE_SENSITIVE_LOGON"

from SQLPLus

Show Parameter SEC_CASE_SENSITIVE_LOGON

Oracle Client

select *
from v$spparameter
where upper(name) = 'SEC_CASE_SENSITIVE_LOGON'

To disable this option,

ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

No comments:

Post a Comment