0 Replies Latest reply on Jul 20, 2012 12:52 PM by 950753

    DB view query (conditional) monitoring


      I have a requirement to monitor database queries on a particular database view involving a data depending condition.
      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.