Supported operations
MySQL | PostgreSQL | SQL Server
This page shows all the operations you can use for theops audit log setting.
Operation groups
The following is a list of operation groups and each operation in the groupsupported 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_tablerename_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 aboutMySQL database auditing.
- Learn about how to useUse MySQL database auditing.
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-12-17 UTC.