Ensure the TXSQL SQL Firewall Is Enabled

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.

-- Check the SQL firewall switch SHOW GLOBAL VARIABLES LIKE 'txsql_sql_filter_enable'; -- View configured filter rules and their hit/reject statistics SELECT * FROM information_schema.txsql_sql_filter_info; Confirm txsql_sql_filter_enable = ON, and that interception rules are configured for critical scenarios (financial transaction tables, user data tables).

Cara perbaikan

Metode perbaikan: Panduan atau patch infrastruktur

Configuring rules through the OSS management interface is recommended (OSS validates rule legality before pushing). If executing SQL directly as an administrator, the rule syntax of the txsql_sql_filter variable is: -- Enable the SQL firewall SET GLOBAL txsql_sql_filter_enable = ON;