Ensure No Excessive `PROCESS` Privilege Grants

中等級 2人工審核tdsql

說明

The PROCESS privilege allows users to view the current queries of all threads and users (SHOW PROCESSLIST), potentially exposing sensitive data contained in other users' SQL statements.

檢查方式

稽核方法: 人工審核

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

SELECT User, Host FROM mysql.user WHERE Process_priv = 'Y' AND User NOT LIKE 'tdsqlsys%'; Confirm only system accounts and approved administrators hold this privilege.

修補方式

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

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

屬性

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