PT-2023-22785 · Archery · Archery
Sylwia-Budzynska
·
Published
2023-04-18
·
Updated
2023-04-29
·
CVE-2023-30558
CVSS v3.1
6.5
Medium
| Vector | AV: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
Found an issue in the description? Have something to add? Feel free to write us 👾
Weakness Enumeration
Related Identifiers
Affected Products
Archery