Forum Stats

  • 3,836,735 Users
  • 2,262,175 Discussions
  • 7,900,088 Comments

Discussions

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

Rajneesh S-Oracle
Rajneesh S-Oracle Posts: 408 Employee
edited Dec 18, 2019 11:05AM in Database Security - General

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 !!!

Rajneesh S-Oracle

Best Answer

Answers