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
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
Previous Topic: Variable passing please explain difference between T-SQL and PL/SQL
Next Topic: Help 2 Oracle scripts
Goto Forum:

Current Time: Sun Aug 20 14:27:24 CDT 2017

Total time taken to generate the page: 0.28384 seconds