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