Database Software

Hi All,


This is my first question, so please bear with me.

I am a developer for a certain company, and I am working with Peoplesoft Enterprise, and the databases are all Oracle's. I found out that some tables have triggers, where various changes are being inserted to another table. For example, changes on the table PS_JOB would be inserted to the table PS_AUDIT_JOB. If I am a database administrator and would update PS_JOB, my actions would also be reflected on PS_AUDIT_JOB.

Sometimes, weird stuff happens on employees' data, so we conduct backend investigation. There are times when the culprit turns out by looking at the audit table. But there are also times when no culprit is ever found. Since I'm kinda into conspiracy theory, I theorized that maybe some priviledged DBAs the power to update the audit table. That said, I searched for priviledges on some audit tables, and found out that some DBAs really do have the priviledges to perform update/delete on these tables.

So, my question is, is there another way to audit these audit tables for any more actions? (no more triggers on the audit tables)


Thanks in advance.