Audit local repository framework
Job details
| Name: | Audit local repository framework |
| Platform: | Oracle |
| Category: | Audit |
| Description: | Task that installs and upgrades the procedure for retrieving audit data in an audit repository when repository and source is on same schema(For test). |
| Long description: | |
| Version: | 2.4 |
| Default schedule: | * * * * |
| Requires engine install: | Yes |
| Compatibility tag: | .[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’] |
Parameters
| Name | Default value | Description |
|---|
Job Summary
- Purpose: The purpose of this job is to manage and ensure the integrity and consistency of auditing data within an Oracle database environment. It specifically handles tasks related to the installation, management, and upgrade of procedures to efficiently retrieve and handle audit data stored in a local repository.
- Why: This job is crucial for maintaining security and compliance in database systems by ensuring that auditing mechanisms are functioning correctly and efficiently. These routines help in detecting discrepancies such as missing or altered records in the audit data, which could be indicative of security breaches or malfunctions.
- Manual checking: While the system automatically handles the tasks, a database administrator can manually check the state of the audit tables and procedures by running SQL commands that query the `dbw_audit`, `dbw_audit_error`, and other relevant audit tables.
Detailed Task Description
The job is tasked with various responsibilities, broken down as follows:
- “Audit local repository framework”: Installs and upgrades the procedure for retrieving audit data within the same schema.
- Database Objects:
- Tables like `dbw_audit`, `dbw_audit_error`, and `dbw_aud_repo_stats` for storing audit records, errors, and statistics.
Dependency Overview
- Dependencies on other objects include various routines and procedures that ensure complete, consistent sets of audit data via checksum validations and data processing sequences.
Installation and Implementation
Auditing procedures and tables are pre-set in the Oracle database according to the provided SQL `CREATE` commands within the implementation section of the job setup.
DBWatch Report Framework Integration
- “Audit Framework”: A reporting template is configured to present facts about the audit records collected:
- Includes a dual-axis chart and data table displaying numbers of imported records and the current total in the audit table.
Recovery and Cleanup Procedures
- Every dependency is equipped with a `cleanup-on-fail` attribute which ensures that in any event of a failure, the job retracts all partially executed steps to maintain database consistency and integrity.
This setup ensures a highly reliable and secure audit data management system within the Oracle database environment, adhering strictly to best practices of audit trail management and compliance requirements.