Oracle audit
I am trying to audit all the database activities to the user who has DBA role privilege. I issued the command below:
audit all by username by access;
However, it was not generated the audit trails in event view log when the user is logging into the database using SQL developer from the other machine.
Is there anything missing? Below is the audit parameter value in my system.
Thank you so much for the help!
********************************************************************************************************************
SQL> show parameter audit AUDIT_SYS_OPERATIONS
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string F:\ORACLE\PRODUCT\10.2.0\ADMIN
\DATABASENAMEHERE\ADUMP
audit_sys_operations boolean TRUE