CYBERTEC PostgreSQL Logo

CYPEX Online Academy - Application Audit Section

6.1 Audit section

In order to audit tables in CYPEX, generic changelog triggers are deployed. They send a copy of your changes to a log table. The visual editor then allows you to track all changes in a table and quickly see what has changed where (diff format).

Inside our history table, data is stored in JSON format. This ensures easy analysis, and guarantees that data is stored in a generic, easy-to-handle format– which is not prone to breaking in case data structures change.

More information about changelog triggers:

Database security is always an essential issue in any database application. Especially when critical data is stored, it might be interesting to know who has changed which data when and how. To track changes made to tables in PostgreSQL you can use a generic changelog trigger. CYPEX writes a generic PL/pgSQL function and uses it to audit tables in the system. PostgreSQL provides good support for stored procedures, so this is ideal.

The point of this is to keep track of all changes made to a table. We want to know which operation has taken place. The next important issue is: When a new row is added it will be visible to the trigger procedure. The same applies to deletion and changes.

To find out more, see our blog about changelog triggers, or check Stack Overflow.

< Application file management section | Academy overview | Application data API section >

CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram