MySQL :: MySQL 8.4 Reference Manual :: 29.12.17.1 The firewall_groups Table (original) (raw)

The world's most popular open source database

29.12.17.1 The firewall_groups Table

The firewall_groups table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists names and operational modes of registered firewall group profiles. It is used in conjunction with themysql.firewall_groups system table that provides persistent storage of firewall data; seeMySQL Enterprise Firewall Tables.

The firewall_groups table has these columns:

• NAME
  The group profile name.
• MODE
  The current operational mode for the profile. Permitted mode values are OFF,DETECTING,PROTECTING, andRECORDING. For details about their meanings, see Firewall Concepts.
• USERHOST
  The training account for the group profile, to be used when the profile is in RECORDING mode. The value is NULL, or a non-NULL account that has the format_`username`_@_`hostname`_:
  • If the value is NULL, the firewall records allowlist rules for statements received from any account that is a member of the group.
  • If the value is non-NULL, the firewall records allowlist rules only for statements received from the named account (which should be a member of the group).

The firewall_groups table has no indexes.

TRUNCATE TABLE is not permitted for the firewall_groups table.