--- title: "附录：general_sql_command 支持的完整 SQL 类型 - OceanBase 数据库 V4.4.2 | OceanBase 文档中心" description: 附录：general_sql_command 支持的完整 SQL 类型 本文档用于列举当前版本 general_sql_command 可匹配的完整 SQL 类型清单，便于在安全审计过滤器中按语句类型进行精确过滤。 注意 本附录所对应功能从 V4.4.2 BP1 版本开始支持。 使用说明 该清单用于 AUDIT_LO… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.4.2 LTS # 附录：general_sql_command 支持的完整 SQL 类型 更新时间：2026-07-18 16:42:43 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.4.2/zh-CN/600.manage/500.security-and-permissions/600.security-audit/200.security-audit-of-mysql-mode/600.general-sql-command-supported-sql-types-of-mysql-mode.md) 本文档用于列举当前版本 `general_sql_command` 可匹配的完整 SQL 类型清单，便于在安全审计过滤器中按语句类型进行精确过滤。 #### 注意 本附录所对应功能从 V4.4.2 BP1 版本开始支持。 ## 使用说明 - 该清单用于 `AUDIT_LOG_FILTER_SET_FILTER` 的 `general_sql_command` 字段取值。 - 按字母序排列。 ## SQL 类型清单 以下清单按首字母分组，便于快速检索与后续维护更新。 ### A ```sql ALTER_RESOURCE_POOL ALTER_RESOURCE_UNIT ALTER_TABLE ALTER_VIEW ALTER_SYSTEM ALTER_SYSTEM_SETTP ADD_UPDATESERVER ADMIN_SERVER ADMIN_ZONE ADMIN_MERGE ALTER_DATABASE ALTER_TABLEGROUP ALTER_OUTLINE ADMIN_UPGRADE_CMD ALTER_ROUTINE ANONYMOUS_BLOCK ALTER_PACKAGE ANALYZE ALTER_SEQUENCE ALTER_DISKGROUP_ADD_DISK ALTER_DISKGROUP_DROP_DISK ADD_CLUSTER ALTER_SYSTEM_SET_PARAMETER ALTER_KEYSTORE ALTER_ROLE ALTER_USER_PROFILE AUDIT ALTER_CLUSTER ARCHIVE_LOG ALTER_TABLESPACE ADMIN_ROLLING_UPGRADE_CMD ALTER_PROFILE ALTER_USER ALTER_TRIGGER ALTER_USER_PRIMARY_ZONE ALTER_TYPE ADMIN_RECOVERY ADMIN_RUN_UPGRADE_JOB ADMIN_STOP_UPGRADE_JOB ADD_RESTORE_SOURCE ALTER_RESOURCE_TENANT ARCHIVE_TENANT ADD_ARBITRATION_SERVICE ALTER_SYSTEM_RESET_PARAMETER ALTER_LS_REPLICA ALTER_USER_PROXY ALTER_SERVER ALTER_LOGFILE_GROUP ADMIN_STORAGE ALTER_LS ALTER_CATALOG ALTER_LOCATION ALTER_SENSITIVE_RULE ``` ### B ```sql BOOTSTRAP BUILD_INDEX_SSTABLE BACKUP_DATABASE BACKUP_MANAGE BACKUP_BACKUPSET BACKUP_ARCHIVELOG BACKUP_CLEAN BACKUP_SET_ENCRYPTION BACKUP_SET_DECRYPTION BACKUP_BACKUPPIECE BACKUP_KEY BACKUP_CLUSTER_PARAMETERS ``` ### C ```sql CREATE_TENANT CHANGE_TENANT CREATE_RESOURCE_POOL CREATE_RESOURCE_UNIT CREATE_TABLE CREATE_INDEX CREATE_VIEW CREATE_USER CHANGE_OBI CS_DISKMAINTAIN CLUSTER_MANAGER CLEAR_MEMTABLE CHECK_ROOT_TABLE CLEAR_ROOT_TABLE CREATE_DATABASE CREATE_TABLEGROUP CREATE_TABLE_LIKE CLEAR_LOCATION_CACHE CLEAR_MERGE_ERROR CREATE_OUTLINE CREATE_ROUTINE CALL_PROCEDURE CREATE_PACKAGE CREATE_PACKAGE_BODY CANCEL_TASK CREATE_SYNONYM CLEAR_BALANCE_TASK CREATE_FUNC CREATE_SEQUENCE CREATE_TYPE CREATE_SAVEPOINT CREATE_KEYSTORE CREATE_TABLESPACE CREATE_TRIGGER CREATE_ROLE CREATE_DBLINK CREATE_PUB_SYNONYM CREATE_PROFILE CREATE_RESTORE_POINT CLEAR_RESTORE_SOURCE CREATE_DIRECTORY CREATE_CONTEXT CHECKPOINT_SLOG CREATE_STANDBY_TENANT CANCEL_RESTORE CANCEL_RECOVER_TABLE CREATE_TENANT_SNAPSHOT CLONE_TENANT CANCEL_CLONE CREATE_MLOG CHANGE_EXTERNAL_STORAGE_DEST CHECKSUM_TABLE CREATE_SERVER CREATE_LOGFILE_GROUP CACHE_INDEX CREATE_CATALOG CREATE_CCL_RULE CREATE_LOCATION CREATE_SENSITIVE_RULE ``` ### D ```sql DROP_TENANT DROP_RESOURCE_POOL DROP_RESOURCE_UNIT DROP_TABLE DROP_INDEX DROP_VIEW DROP_USER DEALLOCATE DROP_MEMTABLE DELETE_UPDATESERVER DROP_DATABASE DROP_TABLEGROUP DROP_OUTLINE DROP_ROUTINE DROP_PACKAGE DROP_SYNONYM DROP_FUNC DROP_SEQUENCE DROP_TYPE DROP_TABLESPACE DROP_TRIGGER DROP_ROLE DROP_DBLINK DROP_PUB_SYNONYM DROP_PROFILE DIAGNOSTICS DELETE_POLICY DISABLE_SQL_THROTTLE DROP_RESTORE_POINT DROP_DIRECTORY DISCONNECT_CLUSTER DROP_CONTEXT DROP_TENANT_SNAPSHOT DROP_MLOG DROP_SERVER DROP_LOGFILE_GROUP DROP_CATALOG DROP_CCL_RULE DROP_LOCATION DROP_SENSITIVE_RULE ``` ### E ```sql EXECUTE END_TRANS EMPTY_QUERY ENABLE_SQL_THROTTLE EVENT_JOB_CREATE EVENT_JOB_ALTER EVENT_JOB_DROP ``` ### F ```sql FREEZE FLUSH_CACHE FLUSH_KVCACHE FLUSH_ILOGCACHE FLASHBACK_TENANT FLASHBACK_DATABASE FLASHBACK_TABLE_FROM_RECYCLEBIN FLASHBACK_INDEX FLASHBACK_TABLE_TO_SCN FLUSH_DAG_WARNINGS FLUSH_PRIVILEGES FLUSH_MOCK FLUSH_MOCK_LIST FLUSH_SS_MICRO_CACHE FLASHBACK_STANDBY_LOG FLUSH_TABLE_MOCK FLUSH_SS_LOCAL_CACHE ``` ### G ```sql GRANT GRANT_ROLE GRANT_PROXY ``` ### H ```sql HELP HANDLER_MOCK HBASE_SCAN HBASE_PUT HBASE_DELETE HBASE_APPEND HBASE_INCREMENT HBASE_CHECK_AND_PUT HBASE_CHECK_AND_DELETE HBASE_HYBRID_BATCH HBASE_OTHER HBASE_CHECK_AND_MUTATE HBASE_GET HBASE_BATCH_PUT HBASE_BATCH_DELETE HBASE_BATCH_GET ``` ### I ```sql INSTALL_PLUGIN ``` ### K ```sql KILL KV_INSERT KV_GET KV_DELETE KV_UPDATE KV_INSERT_OR_UPDATE KV_REPLACE KV_INCREMENT KV_APPEND KV_PUT KV_MULTI_GET KV_MULTI_INSERT KV_MULTI_DELETE KV_MULTI_UPDATE KV_MULTI_INSERT_OR_UPDATE KV_MULTI_REPLACE KV_MULTI_INCREMENT KV_MULTI_APPEND KV_MULTI_PUT KV_QUERY KV_QUERY_AND_MUTATE KV_OTHER ``` ### L ```sql LOCK_TENANT LOCK_USER LOAD_TIME_ZONE_INFO LOAD_DATA LOGIN LOGOFF LOCK_TABLE LOAD_INDEX_INTO_CACHE LOAD_LICENSE LOCATION_UTILS_LIST LOCATION_UTILS ``` ### M ```sql MODIFY_TENANT MIGRATE_UNIT MERGE_RESOURCE_POOL MODULE_DATA ``` ### O ```sql OPTIMIZE_TABLE OPTIMIZE_TENANT OPTIMIZE_ALL OLAP_ASYNC_JOB_SUBMIT OLAP_ASYNC_JOB_CANCEL ``` ### P ```sql PREPARE PRINT_ROOT_TABLE PURGE_RECYCLEBIN PURGE_TENANT PURGE_DATABASE PURGE_TABLE PURGE_INDEX PHYSICAL_RESTORE_TENANT PHYSICAL_RESTORE_STANDBY_TENANT ``` ### R ```sql RENAME_USER REVOKE REPORT_REPLICA RESTORE_TENANT_2 REFRESH_SCHEMA RECYCLE_REPLICA RENAME_TABLE RELOAD_GTS RELOAD_UNIT RELOAD_SERVER RELOAD_ZONE RUN_JOB REMOVE_CLUSTER ROLLBACK_SAVEPOINT RELEASE_SAVEPOINT REFRESH_MEMORY_STAT REVOKE_ROLE REFRESH_IO_CALIBRATION RECOVER REMOVE_ARBITRATION_SERVICE REPLACE_ARBITRATION_SERVICE RECOVER_TABLE REPAIR_TABLE REDIS REVOKE_PROXY REBUILD_TABLET REPLACE_TENANT ``` ### S ```sql SPLIT_RESOURCE_POOL SHOW_TABLES SHOW_DATABASES SHOW_COLUMNS SHOW_VARIABLES SHOW_TABLE_STATUS SHOW_SCHEMA SHOW_CREATE_DATABASE SHOW_CREATE_TABLE SHOW_CREATE_VIEW SHOW_CREATE_PROCEDURE SHOW_CREATE_FUNCTION SHOW_PARAMETERS SHOW_SERVER_STATUS SHOW_INDEXES SHOW_WARNINGS SHOW_ERRORS SHOW_PROCESSLIST SHOW_CHARSET SHOW_COLLATION SHOW_TABLEGROUPS SHOW_STATUS SHOW_TENANT SHOW_CREATE_TENANT SHOW_TRACE SHOW_ENGINES SHOW_PRIVILEGES SHOW_PROCEDURE_STATUS SHOW_FUNCTION_STATUS SHOW_GRANTS SET_PASSWORD START_TRANS SWITCH_MASTER SERVER_ACTION SWITCH_ROOTSERVER SWITCH_UPDATESERVER SWITCH_REPLICA_ROLE SET_NAMES SWITCH_RS_ROLE SHOW_RECYCLEBIN SET_DISK_VALID SHOW_CREATE_TABLEGROUP STMT_TYPE_MAX SET_TABLE_COMMENT SET_COLUMN_COMMENT SWITCHOVER SET_ROLE SYSTEM_GRANT SYSTEM_REVOKE SHOW_TRIGGERS SHOW_CREATE_TRIGGER SHOW_QUERY_RESPONSE_TIME SHOW_PROFILE SHOW_RESTORE_PREVIEW SET_REGION_NETWORK_BANDWIDTH SHOW_SEQUENCES SHOW_PROCEDURE_CODE SHOW_FUNCTION_CODE SHOW_CREATE_USER SHOW_PLUGINS SHOW_ENGINE SHOW_OPEN_TABLES SERVICE_NAME SHOW_CHECK_TABLE SHOW_OLAP_ASYNC_JOB_STATUS SET_CATALOG SHOW_CATALOGS SHOW_CREATE_CATALOG SYS_DISPATCH_CALL SHOW_LOCATIONS SHOW_CREATE_LOCATION SHOW_SENSITIVE_RULES SET_PROTECTION_MODE ``` ### T ```sql TABLET_CMD TRUNCATE_TABLE TABLE_TTL TRANSFER_PARTITION TRIGGER_STORAGE_CACHE ``` ### U ```sql USE_DATABASE UPGRADE_VIRTUAL_SCHEMA USER_PROFILE UNINSTALL_PLUGIN ``` ### V ```sql VARIABLE_SET ``` ### W ```sql WASH_MEMORY_FRAGMENTATION ``` ### X ```sql XA_START XA_END XA_PREPARE XA_COMMIT XA_ROLLBACK XA_RECOVER ``` ## 相关文档 - 开启安全审计：[开启安全审计](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005283311) - 过滤器创建函数：[AUDIT_LOG_FILTER_SET_FILTER](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000005287633) 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线