Home » SQL & PL/SQL » SQL & PL/SQL » Logging Key Values during FGA
Logging Key Values during FGA [message #208870] Tue, 12 December 2006 06:49
sriniv
Messages: 1
Registered: December 2006
Location: Chennai, India
Junior Member

Hi All,

My client had a requirement to create audit logs if some one access the confidential information stored in the tables. We found out that the DBMS_FGA does exactly same by setting policies using DBMS_FGA.

But now client has a new requirement where in he wants to know the key field value also to be recorded so that he can query on them. For example if user runs a query which fetches some 10 records, then for those 10 records the key values to be stored so that a search can be performed on the key values.

Can this be done using some Autonomous transactions etc ? Can some one suggest me a best method ? I would like the method to be databased since the application has many ways to access the data like Reports, JSP.

At the moment I have set up FGA policies and capturing the query that accessed the confidential data but I am struggling to capture the number of rows it accessed and the Key field value for each row.

Kind Regards
Srini
Previous Topic: Need dependent details
Next Topic: Help 2 Oracle scripts
Goto Forum:
  


Current Time: Sat Dec 10 05:09:36 CST 2016

Total time taken to generate the page: 0.08090 seconds