I am trying to produce a monthly report on Audit.
I am able to query the
DBA_AUDIT_TRAIL
, for all other users and no issue in that.
I wanted to include the SYS
/SYSDBA
activities in this report and I know this is not recorded in SYS.AUD$
table but its recorded as an operating system files called .AUD
. I know this is done to make sure that DBAs don't go and modify these data.
Because this is just a reporting how can I get this details to my report?
Is there a way I can query the operating system files eg. XXXX.AUD
?
Thanks
Asked by Leo
(21 rep)
Feb 24, 2017, 05:16 PM
Last activity: Mar 12, 2025, 10:04 AM
Last activity: Mar 12, 2025, 10:04 AM