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