| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
