Supported operations

This page shows all the operations you can use for the ops audit log setting.

Operation groups

The following is a list of operation groups and each operation in the group supported by MySQL database auditing.

Operation groups	Operations included
call	call_procedure
dcl	grant , revoke , revoke_all
ddl	alter_db , alter_event , alter_function , alter_procedure , alter_table , alter_user , create_db , create_event , create_function , create_index , create_procedure , create_table , create_trigger , create_udf , create_user , create_view , drop_db , drop_event , drop_function , drop_index , drop_procedure , drop_table , drop_trigger , drop_user , drop_view , rename_table rename_user
dml	delete , delete_multi , insert , insert_select , load , replace , replace_select , truncate , update , update_multi
dql	select
show	show_binlog_events , show_create_event , show_create_func , show_create_proc , show_events , show_function_code , show_grants , show_procedure_code , show_relaylog_events , show_triggers

Operations

The following are the operations supported by MySQL database auditing.

alter_db	create_trigger	drop_user	show_create_event
alter_event	create_udf	drop_view	show_create_func
alter_function	create_user	grant	show_create_proc
alter_procedure	create_view	insert	show_create_trigger
alter_table	delete	insert_select	show_events
alter_user	delete_multi	load	show_function_code
call_procedure	disconnect	rename_table	show_grants
connect	drop_db	rename_user	show_procedure_code
create_db	drop_event	replace	show_relaylog_events
create_event	drop_function	replace_select	show_triggers
create_function	drop_index	revoke	truncate
create_index	drop_procedure	revoke_all	update
create_procedure	drop_table	select	update_multi
create_table	drop_trigger	show_binlog_events

What's next

• Learn about MySQL database auditing .
• Learn about how to use Use MySQL database auditing .