The DBMS_AUDIT_MGMT package provides subprograms to manage audit trail records. The subprograms in the DBMS_AUDIT_MGMT package assist audit administrators in managing audit logs.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
Privileges
All subprograms in the DBMS_AUDIT_MGMT package require the user to have the EXECUTE privilege. By default, the SYSDBA role has the EXECUTE privilege on this package.
Audit trail types
| Constant | Data type | Description |
|---|---|---|
| AUDIT_TRAIL_ALL | PLS_INTEGER | All audit trail types, including standard database audit trail and OS audit trail. |
| AUDIT_TRAIL_AUD_STD | PLS_INTEGER | Standard audit trail. |
| AUDIT_TRAIL_DB_STD | PLS_INTEGER | Standard audit trail. |
| AUDIT_TRAIL_FILES | PLS_INTEGER | OS audit trail. |
| AUDIT_TRAIL_OS | PLS_INTEGER | OS audit trail, covering the audit records stored in the OS files. |
Subprograms
The following table describes the DBMS_AUDIT_MGMT subprograms supported by the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| CLEAN_AUDIT_TRAIL | Deletes archived audit trail records or files. |
| CREATE_PURGE_JOB | Creates a purge job to periodically delete audit trail records or files. |
| DROP_PURGE_JOB | Drops a purge job that is created by using the CREATE_PURGE_JOB procedure. |
| SET_LAST_ARCHIVE_TIMESTAMP | Sets a timestamp to indicate the last archive time of audit records or files. |
| SET_PURGE_JOB_STATUS | Enables or disables the specified purge job. |