Home » RDBMS Server » Security » fine grained auditing (11g)
fine grained auditing [message #495978] Wed, 23 February 2011 10:31 Go to previous message
Barbaros
Messages: 2
Registered: February 2011
Location: Columbus, Ohio
Junior Member
Hi,

I am trying to use FGA to find out how many rows are accessed from a table with identifiers. For example I may have a table with customer IDs; if a query touching our customer ID table gets less than certain number of records (let's say 20) and/or gets more than a number (say 1,000 or getting everything), I want to know about the query that triggered it, and I want to know how many records were used in the result set... in the first case I may suspect that someone is looking for specific records on my customers and I would like to prevent that...in the second case they may be trying to get all my records I may want to prevent that as well. Overall, I would like to monitor and control who is accessing how much data. In other words, I would like to know during a select from a table how many rows were returned; so I can prevent delivery of results if I need to.

Thanks in advance and have a great day
Barbaros
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Autotrace for user account
Next Topic: how to hide password in script
Goto Forum:
  


Current Time: Thu Dec 05 14:43:42 CST 2019