H MySQL Audit Events

This appendix maps audit event names used in MySQL to their equivalent values in the command_class and target_type fields in the Oracle AVDF audit record. You can use the audit events mapped here to create custom audit reports using other Oracle Database reporting products or third-party tools. See also "Oracle Audit Vault and Database Firewall Database Schemas" for Oracle AVDF data warehouse details that may be useful in designing your own reports.

Table H-1 lists the MySQL audit events and the equivalent Oracle AVDF events.

Table H-1 MySQL Audit Events

Source Event command_class target_type

AUDIT

AUDIT

No Mapping

BINLOG DUMP

DUMP

No Mapping

CHANGE USER

CHANGE

No Mapping

CLOSE STMT

CLOSE

No Mapping

CONNECT OUT

CONNECT

No Mapping

CONNECT

CONNECT

No Mapping

CREATE DB

CREATE

No Mapping

DAEMON

DAEMON

No Mapping

DEBUG

DEBUG

No Mapping

DELAYED INSERT

INSERT

No Mapping

DROP DB

DROP

No Mapping

EXECUTE

EXECUTE

No Mapping

FETCH

FETCH

No Mapping

FIELD LIST

LIST

No Mapping

INIT DB

INIT

No Mapping

KILL

KILL

No Mapping

LONG DATA

LONG DATA

No Mapping

NOAUDIT

NOAUDIT

No Mapping

PING

PING

No Mapping

PREPARE

PREPARE

No Mapping

PROCESSLIST

PROCESS

No Mapping

QUERY

QUERY

No Mapping

QUIT

QUIT

No Mapping

REFRESH

REFRESH

No Mapping

REGISTER SLAVE

REGISTER

No Mapping

RESET STMT

RESET

No Mapping

SET OPTION

SET

No Mapping

SHUTDOWN

SHUTDOWN

No Mapping

SLEEP

SLEEP

No Mapping

STATISTICS

STATISTICS

No Mapping

TABLE DUMP

DUMP

No Mapping

TIME

TIME

No Mapping