DATABASE AUTOMATED AUDITING METHOD AND SYSTEM, DEVICE, AND STORAGE MEDIUM

摘要

A database automated auditing method and system, a device, and a storage medium. The method comprises: obtaining a database table to be audited in a database (S100); according to the database table to be audited, generating a trigger corresponding to the database table to be audited, wherein the trigger is used for auditing the data change situation in the database table to be audited according to a user operation type (S200); in response to an operation of a user on the database table to be audited, obtaining the user operation type of the operation, and determining whether the user operation type is a predetermined operation type (S300); when the operation is a predetermined operation type, triggering the trigger to audit the database table to be audited, and obtaining an auditing result, the auditing result comprising a data archive table and a data update table (S400). A trigger corresponding to a database table to be audited is generated according to the name of the database table to be audited, rapid deployment auditing may be performed on a certain database table to be audited, and auditing code may be rapidly unloaded according to requirements, thereby reducing system load.