The DBMS_AUDIT_MGMT system package is used to manage audit trail records. The subprograms provided by the DBMS_AUDIT_MGMT system package can assist audit administrators in managing audit logs.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
DBMS_AUDIT_MGMT Privileges
All subprograms in the DBMS_AUDIT_MGMT system package require the user to have the EXECUTE privilege. By default, the SYSDBA role has the EXECUTE privilege on this system package.
DBMS_AUDIT_MGMT audit tracking types
constant |
Data type |
Description |
|---|---|---|
| AUDIT_TRAIL_ALL | PLS_INTEGER | All audit tracking types. This includes standard database audit tracking and operating system (OS) audit tracking. |
| AUDIT_TRAIL_AUD_STD | PLS_INTEGER | Standard audit. |
| AUDIT_TRAIL_DB_STD | PLS_INTEGER | Standard audit. |
| AUDIT_TRAIL_FILES | PLS_INTEGER | Operating system (OS) audit tracking. |
| AUDIT_TRAIL_OS | PLS_INTEGER | An operating system audit trail refers to audit records stored in operating system files. |
Overview of DBMS_AUDIT_MGMT Subprograms
The following table lists the DBMS_AUDIT_MGMT subprograms supported by the current version of OceanBase Database and provides brief descriptions.
subprogram |
Description |
|---|---|
| CLEAN_AUDIT_TRAIL | Deletes archived audit trail records or files. |
| CREATE_PURGE_JOB | You can create a cleanup job to regularly delete audit trail records or files. |
| DROP_PURGE_JOB | Deleted by usingCREATE_PURGE_JOBThe process creates a cleanup job. |
| SET_LAST_ARCHIVE_TIMESTAMP | Sets a timestamp indicating the last time the audit record or file was archived. |
| SET_PURGE_JOB_STATUS | Enables or disables the specified cleanup job. |