New in 2.4.0
1. Support for Unified Audit Top-SQL highlighted.
Oracle version 19c introduces Top-SQL level audit option in Unified Audit, now supported.
2. Cumulative Final Result for Audit Success and Failure highlighted.
Prior to this version, multiple audit settings on the same topic have been calculated for both Success and Failure until an incrementing final result achieved. Starting with this version, Success and Failure are calculated separately and a final result is reached in the end.
Example (Traditional Audit) below shows assessment for CREATE TABLE (also covered by audit shortcut TABLE) for a certain user and final Audit Mode result by this version of Omega DB Security Reporter and previous ones.
| User | Audit Option | Success | Failure | Version <= 2.3.1 | Version >= 2.4.0 |
| SCOTT | CREATE TABLE | YES | NO | Partial Audit | Partial Audit |
| SCOTT | TABLE | NO | YES | Partial Audit | Partial Audit |
| Final | Partial Audit | Full Audit |
Same concept has been also applied in Unified Audit, where the same audit option assessed for the user can be subject to multiple Unified Audit policies!