Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Rajneesh S-OracleDec 17 2019 — edited Dec 18 2019

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

This post has been answered by JimFx on Dec 18 2019
Jump to Answer

Comments

Post Details

Added on Dec 17 2019
1 comment
342 views