Ensure 'REPLICATION SLAVE' is Not Granted to Non-Administrative Users

中等級 1人工審核mysql

說明

The REPLICATION SLAVE privilege governs whether a given user (in the context of the source server) can request updates that have been made on the source server.

檢查方式

稽核方法: 人工審核

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

Run SELECT GRANTEE FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE PRIVILEGE_TYPE = 'REPLICATION SLAVE'; Ensure only accounts designated for replica users are returned.

修補方式

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

REVOKE REPLICATION SLAVE ON *.* FROM '<user>'@'<host>'; for each non-administrative grantee.

屬性

作業系統: 不限
標籤: mysqldatabaseauthorizationmanual
參考資料: CIS Oracle MySQL Community Server 8.4 Benchmark v1.1.0 - 5.8 Ensure 'REPLICATION SLAVE' is Not Granted to Non-Administrative Users