KENNEY
Well Known Member
We are currently on ERP8 with an Oracle 9i db and would like to enhance the auditing of updates against the security and user tables (F0092,F00950,F98OWSEC) .
As I am sure most of you will attest that the auditing for security updates in oneworld is somewhat limited.
I am investigating the possibility of adding some triggers to Oracle to write duplicate copies of previously changed security records anytime they are altered.
What I am interested in is whether anyone else has undertaken this and or if anyone knows of any detrimental effects this could have on the system.
As I am sure most of you will attest that the auditing for security updates in oneworld is somewhat limited.
I am investigating the possibility of adding some triggers to Oracle to write duplicate copies of previously changed security records anytime they are altered.
What I am interested in is whether anyone else has undertaken this and or if anyone knows of any detrimental effects this could have on the system.