Menu:
information-schema-mysql-firewall-whitelist-table:: The INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST Table
The following sections describe the 'INFORMATION_SCHEMA' tables associated with MySQL Enterprise Firewall (see *note firewall::). They provide views into the firewall in-memory data cache. These tables are available only if the appropriate firewall plugins are enabled.
File: manual.info.tmp, Node: information-schema-firewall-table-reference, Next: information-schema-mysql-firewall-users-table, Prev: firewall-information-schema-tables, Up: firewall-information-schema-tables
The following table summarizes 'INFORMATION_SCHEMA' firewall tables. For greater detail, see the individual table descriptions.
INFORMATION_SCHEMA Firewall Tables
Table Name Description
*note 'MYSQL_FIREWALL_USERS': information-schema-mysql-firewall-users-table.Firewall in-memory data for account profiles
*note 'MYSQL_FIREWALL_WHITELIST': information-schema-mysql-firewall-whitelist-table.Firewall in-memory data for account profile allowlists
File: manual.info.tmp, Node: information-schema-mysql-firewall-users-table, Next: information-schema-mysql-firewall-whitelist-table, Prev: information-schema-firewall-table-reference, Up: firewall-information-schema-tables
The note 'MYSQL_FIREWALL_USERS': information-schema-mysql-firewall-users-table. 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 the 'mysql.firewall_users' system table that provides persistent storage of firewall data; see note firewall-tables::.
The *note 'MYSQL_FIREWALL_USERS': information-schema-mysql-firewall-users-table. table has these columns:
'USERHOST'
The account profile name. Each account name has the format 'USER_NAME@HOST_NAME'.
'MODE'
The current operational mode for the profile. Permitted mode values are 'OFF', 'DETECTING', 'PROTECTING', 'RECORDING', and 'RESET'. For details about their meanings, see *note firewall-concepts::.
File: manual.info.tmp, Node: information-schema-mysql-firewall-whitelist-table, Prev: information-schema-mysql-firewall-users-table, Up: firewall-information-schema-tables
The note 'MYSQL_FIREWALL_WHITELIST': information-schema-mysql-firewall-whitelist-table. table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists allowlist rules of registered firewall account profiles. It is used in conjunction with the 'mysql.firewall_whitelist' system table that provides persistent storage of firewall data; see note firewall-tables::.
The *note 'MYSQL_FIREWALL_WHITELIST': information-schema-mysql-firewall-whitelist-table. table has these columns:
'USERHOST'
The account profile name. Each account name has the format 'USER_NAME@HOST_NAME'.
'RULE'
A normalized statement indicating an acceptable statement pattern for the profile. A profile allowlist is the union of its rules.
File: manual.info.tmp, Node: extended-show, Prev: firewall-information-schema-tables, Up: information-schema