Ensure TXSQL System User Hiding and Anti-Forgery Is Enabled

チェック方法

監査方法: 手動レビュー

この推奨事項は自動ではチェックできません。--include-manual を指定すると、スキャン結果にこの手順付きで一覧表示されます。

-- 1. Execute after logging in as a regular user (should not see tdsqlsys_* users) SELECT User, Host FROM mysql.user WHERE User LIKE 'tdsqlsys_%'; -- 2. Attempt to create a user with the same prefix (should be rejected by the kernel) CREATE USER 'tdsqlsys_attacker'@'%' IDENTIFIED BY 'fake_pass'; -- ERROR XXXX: User 'tdsqlsys_attacker' is reserved for system use. -- 3. Attempt to write directly via INSERT (should be rejected by the kernel) INSERT INTO mysql.user (User, Host) VALUES ('tdsqlsys_evil','%'); -- ERROR XXXX: Modifying system tables is not allowed. -- 4.

修正方法

修正方法: ガイダンスまたは IaC パッチ

These protections are enabled by default out of the box in TDSQL. If system users are visible or can be created, the cluster is not running the TXSQL kernel or has been replaced with stock MySQL, and must be upgraded to the TXSQL kernel.