0 Replies Latest reply: Jul 20, 2012 7:52 AM by 950753 RSS

    DB view query (conditional) monitoring

    950753
      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.