Ensure No Excessive `SUPER` Privilege Grants

高等級 1人工審核tdsql

說明

The SUPER privilege allows many dangerous operations, including modifying global variables, killing other users' queries, and bypassing read-only restrictions.

檢查方式

稽核方法: 人工審核

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

SELECT User, Host FROM mysql.user WHERE Super_priv = 'Y'; Confirm only TDSQL system accounts (such as the necessary tdsqlsys_kp_new) hold the SUPER privilege.

修補方式

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

Revoke the SUPER privilege from unnecessary users: REVOKE SUPER ON *.* FROM 'username'@'host'; In MySQL 8.0, use fine-grained dynamic privileges (such as SYSTEM_VARIABLES_ADMIN, CONNECTION_ADMIN) instead of SUPER.

屬性

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