Ensure Proper Use Of 'SET_ANY_DEFINER'

中等級 1人工審核mysql

說明

Its critical to limit users ability to set and effective authorization ID that is used with executing a view or stored program. This grant provides a method to escalate privileges within MySQL views and procedures.

檢查方式

稽核方法: 人工審核

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

Run SELECT GRANTEE FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE PRIVILEGE_TYPE = 'SET_ANY_DEFINER'; Ensure only administrative users are returned in the result set.

修補方式

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

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

屬性

作業系統: 不限
標籤: mysqldatabaseauthorizationmanual
參考資料: CIS Oracle MySQL Community Server 8.4 Benchmark v1.1.0 - 5.11 Ensure Proper Use Of 'SET_ANY_DEFINER'