Connecting to target databases : Pre-configuration for monitoring target databases : Oracle target database pre-configuration : Enabling FortiDB to delete audit records
 
Enabling FortiDB to delete audit records
To delete audit records from the SYS.AUD$ table, the FortiDB database user requires delete privileges on the SYS.AUD$ table.
 
Because the SYS.AUD$ contains all audit records, when FortiDB deletes audit records, it deletes all audit records, not only the audit records generated for FortiDB monitoring. Therefore, grant this privilege to the FortiDB user only if you understand the implications.
Use the following statement to grant the FortiDB user delete privileges on the SYS.AUD$ table:
grant delete on SYS.AUD$ to <username>
For more information on deleting audit records, see “Oracle audit management”.
See also
Adding (or modifying) a target connection