Ensure No Excessive `FILE` Privilege Grants

高等級 1人工審核tdsql

說明

The FILE privilege allows users to read and write server filesystem files via LOAD DATA INFILE, SELECT ... INTO OUTFILE, LOAD_FILE(), and similar.

稽核方法: 人工審核

此項建議無法自動檢查。當您傳入 --include-manual 時，掃描結果會列出此項目並附帶這些說明。

SELECT User, Host FROM mysql.user WHERE File_priv = 'Y'; Confirm only accounts that genuinely require it hold this privilege.

修補方法: 操作指南或基礎設施修補檔

REVOKE FILE ON *.* FROM 'username'@'host';

作業系統: 不限
標籤: tdsqlprivileges
參考資料: CIS Tencent TDSQL 10.3.22 Benchmark v1.0.0 - 5.6 Ensure No Excessive `FILE` Privilege Grants