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 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. |
