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

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

JimFx

Those are different product with different usage for your overall security policy. Data Vault is used to restrict different types of activities by defining realms. Audit Vault is a stand-along appliance which collects audit records from a variety of databases and OS.

Look at https://www.oracle.com/database/security/products.html  for more information of these products.

Jim

JimFx

Those are different product with different usage for your overall security policy. Data Vault is used to restrict different types of activities by defining realms. Audit Vault is a stand-along appliance which collects audit records from a variety of databases and OS.

Look at https://www.oracle.com/database/security/products.html  for more information of these products.

Jim