TMA-MYSQL-5.2
Ensure 'FILE' is Not Granted to Non-Administrative Users
高等級 1人工審核mysql
說明
The FILE privilege is used to allow or disallow a user from reading and writing files on the server host. Any user with the FILE right granted has the ability to: ; Read files from the local file system that are readable by the MySQL server (this includes world-readable files). ; Write files to the local file system where the MySQL server has write access.
檢查方式
稽核方法: 人工審核
此項建議無法自動檢查。當您傳入 --include-manual 時，掃描結果會列出此項目並附帶這些說明。
Run SELECT GRANTEE FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE PRIVILEGE_TYPE = 'FILE'; Ensure only administrative users are returned in the result set.
修補方式
修補方法: 操作指南或基礎設施修補檔
REVOKE FILE ON *.* FROM '<user>'@'<host>'; for each non-administrative grantee.
屬性
- 作業系統
- 不限
- 標籤
- mysqldatabaseauthorizationmanual
- 參考資料
- CIS Oracle MySQL Community Server 8.4 Benchmark v1.1.0 - 5.2 Ensure 'FILE' is Not Granted to Non-Administrative Users