Ensure System Account Privileges Are Minimized

Cara pemeriksaan

Metode audit: Tinjauan manual

Rekomendasi ini tidak dapat diperiksa secara otomatis. Pemindaian akan menampilkannya beserta petunjuk ini saat Anda memberikan opsi --include-manual.

Run SHOW GRANTS FOR 'tdsqlsys_check'@'%'; SHOW GRANTS FOR 'tdsqlsys_agent'@'%'; SHOW GRANTS FOR 'tdsqlsys_repl'@'%'; (and the other tdsqlsys_* accounts) and compare each with the minimum privileges required for its function per the benchmark table (e.g. tdsqlsys_repl only REPLICATION SLAVE, REPLICATION CLIENT). Any extra privilege is a finding.

Cara perbaikan

Metode perbaikan: Panduan atau patch infrastruktur

Adjust system account privileges through the TDSQL Manager to ensure each account holds only the necessary privileges. Note: Modifying system account privileges may affect normal operation of TDSQL components; test thoroughly before making changes.