TMA-TDSQL-5.7
Ensure No Excessive `PROCESS` Privilege Grants
SedangLevel 2Tinjauan manualtdsql
Deskripsi
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.
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.
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.
Cara perbaikan
Metode perbaikan: Panduan atau patch infrastruktur
REVOKE PROCESS ON *.* FROM 'username'@'host';
Properti
- Sistem operasi
- Apa saja
- Tag
- tdsqlprivileges
- Referensi
- CIS Tencent TDSQL 10.3.22 Benchmark v1.0.0 - 5.7 Ensure No Excessive `PROCESS` Privilege Grants