Sample Header Ad - 728x90

Oracle sys SYSDBA audit information to a report

2 votes
1 answer
818 views
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