1 Reply Latest reply on Dec 18, 2019 3:14 PM by JimFx

    Oracle Data Base 19C - Audit Logging frame work related queries

    Rajneesh Shukla-Oracle

      Hello All,

      I wanted to connect with you to understand below with respect to data base audit logging framework.

      • Database Vault 
      • Oracle Audit Vault

      Both are same , if not then what is key difference?

      Is there any relationship between these two?

      I recently explored fine grain auditing by going through various documents available and understood that it works like below:

      Select statement executed for auditing purpose-
      SELECT * FROM test1.employees WHERE id=1;

      DBA_FGA_AUDIT_TRAIL table:

       

      TIMESTAMP

      DB_USER

      OS_USER

      OBJECT_SCHEMA

      OBJECT_NAME

      SQL_TEXT

      12/17/2019 11:25

      TEST2

      XYZ

      TEST1

      EMPLOYEE

      SELECT * FROM TEST1.EMPLOYEES WHERE ID=1

       

      My question - Is  fine grain auditing part of 19C auditing feature?
      How is it related to Database Vault  and Oracle Audit Vault?
      For example fine grain auditing is sub part of Oracle Audit Vault?

      Basically I have heard so many terms  about data base auditing and wanted to connect dot among them by understanding how they are related and differ with respect to Oracle Database 19c.
      Also what all features still available.

      Thanking you in anticipation !!!