Skip to Main Content
Feature Request FR-3247
Product Area APIs
Status CLOSED

5 Voters

Methods on Tables to include audit functionality on a table

raakeshbc Public · Jul 5 2023

Idea Summary
Create Audit tables, triggers and packages needed to maintain audit information of a table for which API package is generated using Utilities→Methods on Tables→Create Package on Tables.

Use Case
When a table data needs to be audited.

Preferred Solution (Optional)
1. Create Audit table

2. Create Trigger to insert an audit table entry after DML in actual table

3. Provide option to include auditing BLOB/CLOB

This is a great idea! You can already achieve this in APEX today with a slightly different approach.

Comments

Comments

  • vincent morneau Admin OP 1.9 years ago

    Hi @raakeshbc ,

    It would seem that using /auditcols table directive will add the audit columns, and create the trigger.

  • monica.godoy Admin OP 1.9 years ago

    Hi @raakeshbc,

    Just to be clear, with Quick SQL you can use the /auditcols table directive to meet these requirements.
    If your table is already created, you can create a new table with the audit directive, and migrate the data into this new table structure.

    Thanks for submitting this idea.

  • raakeshbc OP 1.9 years ago

    @vincent morneau @monica.godoy Thanks for these updates.

    I may have missed the details about what an audit could entail beyond capturing data creation and update information within the same table. My Feature Request is for Row-level auditing of the kind described in this Oracle blog which speaks of creating triggers which store audited row-level changes in an Audit table.

    Let me know if more information/explanation is required.