VYPR
← All advisories
High severityNVD Advisory· Published Jul 24, 2024· Updated Aug 2, 2024

DuckDB: sniff_csv provides filesystem access even when enable_external_access is disabled

CVE-2024-41672

Description

DuckDB is a SQL database management system. In versions 1.0.0 and prior, content in filesystem is accessible for reading using sniff_csv, even with enable_external_access=false. This vulnerability provides an attacker with access to filesystem even when access is expected to be disabled and other similar functions do NOT provide access. There seem to be two vectors to this vulnerability. First, access to files that should otherwise not be allowed. Second, the content from a file can be read (e.g. /etc/hosts, proc/self/environ, etc) even though that doesn't seem to be the intent of the sniff_csv function. A fix for this issue is available in commit c9b7c98aa0e1cd7363fe8bb8543a95f38e980d8a and is expected to be part of version 1.1.0.

Affected packages

Versions sourced from the GitHub Security Advisory.

PackageAffected versionsPatched versions
duckdbPyPI
>= 1.0.0, < 1.1.01.1.0

Affected products

1

Patches

1
c9b7c98aa0e1

Merge pull request #13133 from hannes/sniffexternal

https://github.com/duckdb/duckdbMarkJul 24, 2024via ghsa
commitPR #13133
2 files changed · +10 −0
  • src/function/table/sniff_csv.cpp+4 −0 modified
    @@ -36,6 +36,10 @@ static unique_ptr<GlobalTableFunctionState> CSVSniffInitGlobal(ClientContext &co
 static unique_ptr<FunctionData> CSVSniffBind(ClientContext &context, TableFunctionBindInput &input,
                                              vector<LogicalType> &return_types, vector<string> &names) {
 	auto result = make_uniq<CSVSniffFunctionData>();
+	auto &config = DBConfig::GetConfig(context);
+	if (!config.options.enable_external_access) {
+		throw PermissionException("sniff_csv is disabled through configuration");
+	}
 	result->path = input.inputs[0].ToString();
 	auto it = input.named_parameters.find("auto_detect");
 	if (it != input.named_parameters.end()) {
  • test/sql/copy/csv/csv_external_access.test+6 −0 modified
    @@ -31,3 +31,9 @@ COPY date_test TO '__TEST_DIR__/date.csv'
 statement error
 SET enable_external_access=true;
 ----
+
+# sniffer also respects external access flag
+statement error
+FROM sniff_csv('test/sql/copy/csv/data/test/date.csv');
+----
+Permission Error: sniff_csv is disabled through configuration

Vulnerability mechanics

Generated by null/stub on May 9, 2026. Inputs: CWE entries + fix-commit diffs from this CVE's patches. Citations validated against bundle.

References

6

News mentions

0

No linked articles in our index yet.