Srinivasan -- Thanks for the question regarding "Auditing Users Accessing Confidential Data", version 9.0.2

You Asked

Hi

My client had a requirement to log users accessing certain fields in a table. I found 
DBMS_FGA to fulfill this requirement. Its logging the query used to access the data by 
the user.

But now the client says, he wants to log the Key value of that record so that he can 
easily identify the user who accessed that record rather than going thru 100s of queries. 
I am not sure how I can do this.

I need a solution thats based on DB level since in my application user can access data 
from various sources like JDBC, ODBC, Discoverer, Oracle Reports via JDBC, Oracle Reports 
from Desktop, SPSS etc. It has to be a DB level solution. Thats the main reason we opted 
for DBMS_FGA in the first place.

Kind Regards
Srini 

and we said...

dbms_fga audits not only the query, but the bind variables used

the information you are looking for is there in the dbms_fga audit log already.  You have 
it.


 

Reviews
December 12, 2006 - 8pm Central time zone Bookmark | Bottom | Top Reviewer: Srinivasan Venkataraman from Chennai, India

Write a Review