28.7.2 The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table (original) (raw)

The world's most popular open source database

28.7.2 The INFORMATION_SCHEMA MYSQL_FIREWALL_USERS Table

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

The MYSQL_FIREWALL_USERS table has these columns:

• USERHOST
  The account profile name. Each account name has the format_`username`_@_`hostname`_.
• MODE
  The current operational mode for the profile. Permitted mode values are OFF,DETECTING, PROTECTING,RECORDING, and RESET. For details about their meanings, seeFirewall Concepts.

This table is deprecated and subject to removal in a future MySQL version. See Migrating Account Profiles to Group Profiles.