How powerful is logminer

[adewri]

Hi,

I havent tried using logminer yet.
Can logminer solve this problem in our systems Or is there a better alternative.
Our problem is like this:
We have a "blacklist" table where names of people not allowed to leave the country
are entered. This is in connection with a filed case from a complainant. We have a
counter officer (airport) that checks the blacklist tables everytime a passenger leaves
the port. It happened sometimes that when an officer "hits" a blacklisted person, the
persons tends to negotiate and offer some bribe, which in turn the officer accepts. Then when the complainant "complaints" why the person was able to leave the country, The officer will just deny that he found match in the database.
So, can we list daily all the queries in the blacklist table that has "matched" by officer
userid using the logminer? or we have to make utility programs to resolve this.

Thanks a lot

If you are matching using names, then more than one person can have same name and some names are so common that you can meet 2-3 person of the same name in a day (at the airport). So what do you do? Detain every person having the blacklisted name?

And every name matching will be doing a select.