Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.9Mb
PDF (A4) - 42.0Mb
Man Pages (TGZ) - 266.1Kb
Man Pages (Zip) - 376.0Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

27.12.17.3 The firewall_membership Table

The firewall_membership table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists the members (accounts) of registered firewall group profiles. It is used in conjunction with the mysql.firewall_membership system table that provides persistent storage of firewall data; see MySQL Enterprise Firewall Tables.

The firewall_membership table has these columns:

  • GROUP_ID

    The group profile name.

  • MEMBER_ID

    The name of an account that is a member of the profile.

The firewall_membership table has no indexes.

TRUNCATE TABLE is not permitted for the firewall_membership table.

The firewall_membership table was added in MySQL 8.0.23.