IB Asynchronous - AUDIT_OPRID to reflect LASTUPDOPRID
Hi Community!
We're facing an issue which I thought I might ask you all first. Currently, we have IB Asynchronous messages coming in to store Job Data. In our audit record, PS_AUDIT_JOB, AUDIT_OPRID stores our Database name which we don't want as it doesn't mean anything to our users and makes it harder for us to track who did the change. I know that JOB has LASTUPDOPRID but we have other records which don't store this eg. COMPENSATION, etc. I was wondering if anyone knows how to might be able to set this to the person who actually triggered/made the change?