Frappe HR is an open-source human resources management solution (HRMS). Prior to 16.7.0, an authenticated user with the HR User role can inject SQL through filters in the Salary Payments Based on Payment Mode report. In hrms/payroll/report/salary_payments_based_on_payment_mode/salary_payments_based_on_payment_mode.py, get_conditions constructs filter clauses from user-controlled values and get_data incorporates those clauses into a string-formatted SQL query, allowing extraction of arbitrary database data.
This issue is fixed in 16.7.0.
Attack Parameters
Attack Vector
Network
Can be exploited remotely
Attack Complexity
Low
Easy to exploit
Attack Requirements
None
No additional conditions
Privileges Required
Low
Basic privileges needed
User Interaction
None
No user interaction needed
Impact Assessment
Confidentiality
High
Complete data leak
Integrity
None
No data modification
Availability
None
No disruption
CVSS Vector v4.0
Weakness Type (CWE)
References 4
https://github.com/frappe/hrms/commit/b16148531954531a448dafdff20dc61882430ee9
security-advisories@github.com
https://github.com/frappe/hrms/pull/4515
security-advisories@github.com
https://github.com/frappe/hrms/releases/tag/v16.7.0
security-advisories@github.com
https://github.com/frappe/hrms/security/advisories/GHSA-2gv7-x4h2-3737
security-advisories@github.com