If a User asks to retrieve or update a Table for which he or she does not have the necessary privilege, we want to be able to report such - However we do NOT want to incur the overhead of having ALL of the responses/result-sets sent from the database severer to the collector for SQL statements which are not in error.
Another attempt to be clear:
As far as the volume of "traffic" which goes from the database server to the collector is concerned, we want a couple of things - which, as we understand anyway, appear to be mutually exclusive.
1] We want to know any time an SQL Error happens (and what specifically it is), and
2] We do not want every SQL response to be sent to the collector (e.g. if the SQL completes successfully we do not need to have the resultant rows sent to the collector) -- the incoming SQL statement is enough - which is what DAM is primarily designed to capture (at lease as we understand it - given what functions we use).
Do not place IBM confidential, company confidential, or personal information into any field.