PT-2023-22785 · Archery · Archery

Sylwia-Budzynska

·

Published

2023-04-18

·

Updated

2023-04-29

·

CVE-2023-30558

CVSS v3.1

6.5

Medium

VectorAV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N
Name of the Vulnerable Software and Affected Versions Archery (affected versions not specified)
Description The Archery project contains multiple SQL injection vulnerabilities that may allow an attacker to query the connected databases. User input coming from the db name in the sql/data dictionary.py table list endpoint is passed to the methods that follow in a given SQL engine implementations, which concatenate user input unsafely into a SQL query and afterwards pass it to the query method of each database engine for execution. The affected methods are get group tables by db in sql/engines/mssql.py and get group tables by db in sql/engines/oracle.py. Each of these issues may be mitigated by escaping user input or by using prepared statements when executing SQL queries.
Recommendations As a temporary workaround, consider disabling the get group tables by db function in sql/engines/mssql.py and sql/engines/oracle.py until a patch is available. Restrict access to the table list endpoint in sql/data dictionary.py to minimize the risk of exploitation. Avoid using the db name variable in the affected API endpoint until the issue is resolved. At the moment, there is no information about a newer version that contains a fix for this vulnerability.

Exploit

SQL injection

Weakness Enumeration

Related Identifiers

CVE-2023-30558
GHSA-JWJJ-JGFV-X66Q

Affected Products

Archery