audit_log_user表 - xiaoboluo768/mysql-system-schema GitHub Wiki
- 该表提供查询过滤规则与关联帐号之间映射关系
- 表结构定义
CREATE TABLE `audit_log_user` (
`USER` varchar(16) COLLATE utf8_bin NOT NULL,
`HOST` varchar(60) COLLATE utf8_bin NOT NULL,
`FILTERNAME` varchar(64) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`USER`,`HOST`),
KEY `FILTERNAME` (`FILTERNAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin- 表字段含义
- USER：用户名，与mysql.user表中的USER字段含义相同
- HOST：主机名，与mysql.user表中的HOST字段含义相同
- FILTERNAME：过滤规则名称
- 表记录内容示例
root@localhost : mysql 10:32:58> select * from audit_log_user;
+------+------+------------+
| USER | HOST | FILTERNAME |
+------+------+------------+
| % | | log_all |
+------+------+------------+
1 row in set (0.00 sec)上一篇：audit_log_filter表 |下一篇：防火墙规则表