Enabling 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 on page 1.