This discussion is archived
0 Replies Latest reply: Jul 20, 2012 5:52 AM by 950753 RSS

DB view query (conditional) monitoring

950753 Newbie
Currently Being Moderated
Hi,

I have a requirement to monitor database queries on a particular database view involving a data depending condition.
Example
COL1 COL2 COL3
001 XXX ABC
002 YYY ABC
003 XXX XYZ

If someone query for COL3 = XYZ (results set has the row where COL3 = XYZ) then I need to trigger an email notifying that to a user. But if the same user query the same table and did not get the row with COL3 = XYZ in the result set then it should not send out the notification.
Is this possible to achieve without FGA? I can't use fga since the DB is Oracle 10g standard edition.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points