CVE-2014-8161

PostgreSQL before 9.0.19, 9.1.x before 9.1.15, 9.2.x before 9.2.10, 9.3.x before 9.3.6, and 9.4.x before 9.4.1 allows remote authenticated users to obtain sensitive column values by triggering constraint violation and then reading the error message.

Weakness

The product generates an error message that includes sensitive information about its environment, users, or associated data.

Affected Software

Potential Mitigations

• Ensure that error messages only contain minimal details that are useful to the intended audience and no one else. The messages need to strike the balance between being too cryptic (which can confuse users) or being too detailed (which may reveal more than intended). The messages should not reveal the methods that were used to determine the error. Attackers can use detailed information to refine or optimize their original attack, thereby increasing their chances of success.
• If errors must be captured in some detail, record them in log messages, but consider what could occur if the log messages can be viewed by attackers. Highly sensitive information such as passwords should never be saved to log files.
• Avoid inconsistent messaging that might accidentally tip off an attacker about internal state, such as whether a user account exists or not.

Related Attack Patterns

• https://cwe.mitre.org/data/definitions/215.html
• https://cwe.mitre.org/data/definitions/463.html
• https://cwe.mitre.org/data/definitions/54.html
• https://cwe.mitre.org/data/definitions/7.html

References

• http://www.debian.org/security/2015/dsa-3155
• http://www.postgresql.org/about/news/1569/
• http://www.postgresql.org/docs/9.4/static/release-9-4-1.html
• http://www.postgresql.org/docs/current/static/release-9-0-19.html
• http://www.postgresql.org/docs/current/static/release-9-1-15.html
• http://www.postgresql.org/docs/current/static/release-9-2-10.html
• http://www.postgresql.org/docs/current/static/release-9-3-6.html
• http://www.debian.org/security/2015/dsa-3155
• http://www.postgresql.org/about/news/1569/
• http://www.postgresql.org/docs/9.4/static/release-9-4-1.html
• http://www.postgresql.org/docs/current/static/release-9-0-19.html
• http://www.postgresql.org/docs/current/static/release-9-1-15.html
• http://www.postgresql.org/docs/current/static/release-9-2-10.html
• http://www.postgresql.org/docs/current/static/release-9-3-6.html