Database Security Products (MOSC)

MOSC Banner

What is impact of Database Vault impact on AUDIT_TRAIL

edited Jun 20, 2018 3:35PM in Database Security Products (MOSC) 3 commentsAnswered ✓

12.1.2.7

Linux x86-64

Oracle Linux 6

Audit Vault (12.1.2.7.0) and Database Vault enabled


This questions has a few angles to it, any help or insight would be greatly appreciated:


There's a database user that will be used to remotely access the AUDIT_TRAIL and CHECKPOINT tables. 


As AVSYS, SELECT obj priv on these tables was granted to the remote access user. 


The remote access user can query the CHECKPOINT table and get the correct results, data and # or rows.


When the remote access user attempts to query the AUDIT_TRAIL table, it gets "no rows", even though there are several dozen audit trails. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center