Forum Stats

  • 3,854,098 Users
  • 2,264,315 Discussions
  • 7,905,557 Comments

Discussions

How to stop generating audit trace files for sys user??

User_KYWTC
User_KYWTC Member Posts: 17 Green Ribbon
edited Jun 13, 2020 1:15PM in Database Security - General

Hi Team

My current environment is 12.1.0.2 and we are in mixed mode auditing.

We could see audit trace files are still getting generated even after making audit_sys_operations=false . Is there anyway to stop generating these trace files?

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

audit_sys_operations                 boolean     FALSE

Audit_file_dest

=============

-rw-r-----. 1 oracle oinstall 2.1K Jun  4 13:41 REVSND00_ora_15642_20200604134058036954143795.aud

-rw-r-----. 1 oracle oinstall  724 Jun  4 13:41 REVSND00_ora_15687_20200604134125979544143795.aud

-rw-r-----. 1 oracle oinstall  728 Jun  4 13:41 REVSND00_ora_15750_20200604134126049767143795.aud

-rw-r-----. 1 oracle oinstall  731 Jun  4 13:41 REVSND00_ora_15767_20200604134130211577143795.aud

Best Answer

  • User_KYWTC
    User_KYWTC Member Posts: 17 Green Ribbon
    edited Jun 13, 2020 1:15PM Answer ✓

    Yes, there is no way to disable the trace files as logins by sysdba/sysoper are enabled by default. But when you enable pure unified auditing mode, none of the trace files are getting generated in adump directory.

    Thanks for your time.

Answers