FILE privilege was not checked for subqueries in the FROM clause
Package
No package listed
Affected versions
10.6.1-10.6.25, 10.11.1-10.11.16, 11.4.1-11.4.10, 11.8.1-11.8.6, 12.3.1
Patched versions
10.6.26, 10.11.17, 11.4.11, 11.8.7, 12.3.2.
Impact
MariaDB allowed
SELECT ... INTO OUTFILEandSELECT ... INTO DUMPFILEwithout verifying theFILEprivilege if theFROMclause contained only subqueries.Patches
Fixed in 10.6.26, 10.11.17, 11.4.11, 11.8.7, 12.3.2.
Workarounds
Filesystem privileges and
--secure-file-privoption still apply and should always be used to limit locations that the server can write to.References
https://jira.mariadb.org/browse/MDEV-39493
Credits
Tomer Fichman