TMAegis
Više pravila za tdsql

TMA-TDSQL-5.7

Ensure No Excessive `PROCESS` Privilege Grants

SrednjaNivo 2Ručni pregledtdsql

Opis

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.

Kako se proverava

Metod provere: Ručni pregled

Ova preporuka se ne može proveriti automatski. Skeniranje je navodi sa ovim uputstvima kada prosledite --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.

Kako se ispravlja

Metod ispravke: Smernica ili zakrpa infrastrukture

REVOKE PROCESS ON *.* FROM 'username'@'host';

Svojstva

Operativni sistemi
Bilo koji
Oznake
tdsqlprivileges
Referenca
CIS Tencent TDSQL 10.3.22 Benchmark v1.0.0 - 5.7 Ensure No Excessive `PROCESS` Privilege Grants