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.