2.2.12 Ensure 'SEC_CASE_SENSITIVE_LOGON' Is Set to 'TRUE'

Information

Oracle 11g databases without CPU October 2012 patch or later are vulnerable to CVE-2012-3137 if case-sensisitve SHA-1 password hashes are used. To avoid this kind of attack the old DES-hashes have to be used.

Solution

To remediate this setting execute the following SQL statement. ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = TRUE SCOPE = SPFILE; Impact: If SEC_CASE_SENSITIVE_LOGON is FALSE, all user with SHA-1 hashes only ('select name,password,spare4 from sys.user$ where password is null and spare4 is not null') are no longer able to connect to the database. In this case the password for all users without DES hash have to set again.

See Also

https://workbench.cisecurity.org/files/601